bis816649
asked on
Disable Auto_Open Macro when Opening Spreadsheet
I have a spreadsheet which resides in a trusted location. It has signed macros (via code signing certificate), one of which is an AUTO_OPEN macro.
How can I prevent the AUTO_OPEN macro from executing when I open the spreadsheet for maintenance.
How can I prevent the AUTO_OPEN macro from executing when I open the spreadsheet for maintenance.
ASKER
Thanks Nike_Golf, but holding down the SHIFT key does not prevent my AUTO_OPEN macro from executing.
Keep on pressing ESC key....it wont let the macro execute...or when u open it..u can open it by clicking on disable macro..which is an other way arround....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Don. Have added code as per MS KB article 555263
NG,