« Rounding Time
Determine If Event Exists »

Disabling Startup Macros

August 31, 2004, 9:34 am by Dick Kusleika

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.

Category: VBA Basics  |  Comment (RSS)

2 Comments

  1. Zoltan Till says:
    August 31, 2004 at 10:52 am

    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

  2. David Crompton says:
    May 24, 2007 at 3:45 am

    So how do you disable bypass keys in Excel

To post VBA code in your comment, use <code> tags, like this: <code lang="vb">Code goes here</code>.

Leave a Reply