Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Partially solved: The document was called "Master.ods".

The macro was stored in that document, in Master.ods/VBAProject/Modules/Module1. I edited the macro, and copied the macro code.

I then copied the macro into My Macros/Standard/Module1(by editing Main, and pasting the code from above).

After saving and reloading the document, all macros worked perfectly.

I had tried using the macro Organizer, with no success. It seems to me that the problem is in getting Calc to recognise where the macro is stored, which would explain why each of my methods worked. A full solution would solve that problem.