Excel Tip of the Day
Prevent startup Excel macros from running (97/2000/2001/2002)
Macros are supposed to make your life easier, but sometimes they may get in the way. For instance, you may have workbooks that automatically run macros when they're opened. When you need to quickly check out some existing data as you're rushing off to a meeting, sitting through the macro can seem to be an eternity. Fortunately, you can easily prevent startup macros from running. Simply hold down the [Shift] key when you open the file. Note that you'll need to keep the [Shift] key pressed throughout any warning dialog boxes that may appear during the process.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.