Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

No computer access Right now so everything I say is going to be a guess.

If you are looking to cause functions to recalculate, I think that might be a setting not related 
to macros. Because you can turn off auto recalculation. Also, you can force a full update. I know 
it's on the menu. I don't remember the key strokes but I know it's there something like tools 
recalculator something or maybe it's update all I guess

That said, you can associate events to macros. I do believe. I don't do it often, but I believe you 
can. So you can set a macro to run when a document opens and maybe that's what you want.

I don't remember offhand how to get to events. You can associate a macro to run when an event 
occurs, but I have done it. I designed some macros for a company that wanted things to auto 
calculate when they opened a template.

For me, learning macros was easier by simply looking at examples and then modifying them for my own 
uses. But you're asking how to cause macros to run based on certain conditions, not how do you 
accomplish a specific task.

Best of luck.

⁣Get BlueMail for Android ​

On Dec 23, 2022, 10:51 AM, at 10:51 AM, Michael Tiernan <> wrote:
I have a couple of BASIC macros in a spreadsheet.

I keep thinking that there must be a "init" function that isn't being 
called because each time I open the spreadsheet, the macros don't run.
have to mess about a bit and then force each cell to recalculate 
manually. (I'm sure that there's a global 'recalculate' button/tool 
somewhere but that's secondary to the problem.)

I know there's a lot of documentation out there on macros (almost too 
much) but I'm not sure where to start reading, does anyone have a 
pointer that would address, not how to create a macro but how to 
incorporate it to become automatic?


  << MCT >> Michael C Tiernan.
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.