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 <michael.tier...@gmail.com> 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. >I >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? > >Thanks. > >-- > << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan > 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: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
