To prevent macros from executing when a workbook is opened, such as the Workbook_Open event or an Auto_Open macro, hold down the Shift key while you open the workbook.
2 thoughts on “Disabling Startup Macros”
Posting code? Use <pre> tags for VBA and <code> tags for inline.
Hi Dick,
This solution works in MS Access also.
If you want to disable the bypass then you can use this:
http://www.microsoft-accesssolutions.co.uk/disable_shift_bypass.htm
Zoltan
So how do you disable bypass keys in Excel