I'm trying to write a macro to lock all 42 of my magic sheets. I tried Magic Sheet 1 thru 42 Enter Lock Enable Enter and several other combinations. Is there a way to do this?
Lloyd
I'm trying to write a macro to lock all 42 of my magic sheets. I tried Magic Sheet 1 thru 42 Enter Lock Enable Enter and several other combinations. Is there a way to do this?
Lloyd
Not sure if Magic sheet lock works via a macro but on the 42 times thing, there is a loop function in the macro editor, so something like:
Magic_Sheet 1 Enter
Macro_Loop_Begin 42 Enter
<special locking macro for a single magic sheet>
Next Macro_Loop_End Enter
would get it to work through all of them
The Magic Sheet Lock function is not macroable.
www.etcconnect.com