Hi. All of a sudden yesterday all my macros disappeared for Calc. Every cell in my spreadsheets that referenced a macro that I had written showed up with the string #NAME? in it.
Fortunately, I keep a backup on a different machine. I can see the Macros functioning in the spreadsheets that reference them on the backup machine.
So, I thought I would copy-and-paste the code from the Macros on that machine into the Visual Basic editor on the machine on which the macros disappeared. But, when I try to look at the macros on the backup machine, the code is
nowhere to be found. It must be there or the macros wouldn’t be running and giving the correct results.
So, how do I find them?
Please help. Also, can someone suggest why in the world my macros would have suddenly disappeared in the first place? Is this related to the phenomenon whereby my dictionary suddenly disappears every once in a while in the wordprocessor?
Thank you ahead of time for any help!