I have number of macros in a calc worksheet located in My Macros but dont see them if I open the sheet in another machine. I now realise that I should have saved them in the worksheet itself! Is there an easy way to fix this so that I can run the same worksheet in both machines, maybe using the macro organiser? I am a newbie with Libre Office and I am just finding my feet with the program. Please help
Tools>Macros>Organize…
Button [Organizer…]
Tab “Modules”
Now drag the modules from the library under “My Macros” to a library in the respective document or template. This will move the modules.
If you want to copy them, do a drag&Ctrl+Drop.
Point the events, (toolbar-) buttons, controls that used to call the old macro to the new macro.