Prevent that an Automacro/Eventmacro executes

 1999-08-21    Events    0    59

If you wish to open a workbook without running an Auto_Open-macro, you can do this by holding the Shift-key down when you open the file. If the workbook is password protected, remember to hold the Shift-key down after you have entered the password. An Auto_Open-macro will not run automatically when you open a workbook from another macro. If you want this to Auto_Open-macro you will have to set the method RunAutoMacros to True before opening the other workbook from your code.

You can prevent an Auto_Close-macro to run by holding the Shift-key down when you close the workbook.

The same applies to all the other auto-macros, hold the Shift-key down to prevent them from running.

In Excel 97 and later, events are used to run macros. Excel 97 and later will also recognize and run the older auto-macros if they exist. The eventmacros will run before the automacros, e.g. the Workbook_Open eventmacro will run before the Auto_Open-macro.

In Excel 97 and later you can disable the eventmacros by adding this line to your code:

Application.EnableEvents = False
Remember to set the property back to True so that eventmacros are enabled again when you are finished.

Leave a comment:

Your comment will only be published after it has been moderated and found spam free.
Your e-mail address will only be used to display your Gravatar.