I was viewing formulas and doing maintenance on one of my calc sheets. When I finished I noticed that my macros were gone. I have them in last year’s sheet. Can I copy them from one sheet to another. If so, how?
If they are macros in Basic, open the Basic IDE. Then use the “Select Module” icon, usually the second from right on the top toolbar. Expand the libraries of each document. Press and hold the Ctrl key while you drag and drop the module from one documents library to the other. This should create a copy of the module in the target document. Repeat this for any other modules.
Using this method you would still need to set up Hot keys, Menus etc to point to the code in the modules.
I am using version 5.0.3.2. The macros were originally written on Excel but worked fine in LibreOffice. I cannot find the Basic IDE, but I can see the macros on last yeas’s version of the sheet under tools/macros/organixe Macros/LibreOffice Bacic
After you follow tools/macros/organize Macros/LibreOffice Basic, then click on Edit to start the Basic IDE