Excel 2000.
I am a raw beginner to VBA and this function is brilliant! Something I had wanted for a looong time.
I then changed the code (in a second module) to 'UnProtect'. That worked too!
However, after saving the protected workbook and re-opening, the macros are disabled, and a message appears: "Open document with macros enabled".
How on earth do I do that? I can find no obvious solution. It's probably staring me in the face if I looked hard enough.
TIA
Alan
Bookmarks