I have code that executes on open. After the code runs, it saves and closes the workbook...which it is supposed to do. HOWEVER, when I disable macros, and try to open my workbook to edit my code, the code still runs, even though my excel settings have macros disabled. What.The.Heck?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VB running with macros disabled
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,888
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
Seems a bit odd and highly unlikely, but have you tried opening the workbook manually, so as not to trigger the macro
To run the workbook without triggering the open macro
Open Excel>>File menu>> "Open" >>locate your file>>Hold down the "Shift" key while you click "Open," and continue holding it until the workbook finishes loading.
To run the workbook without triggering the open macro
Open Excel>>File menu>> "Open" >>locate your file>>Hold down the "Shift" key while you click "Open," and continue holding it until the workbook finishes loading.
Upvote
0
frabulator
Active Member
- Joined
- Jun 27, 2014
- Messages
- 256
- Office Version
- 2019
- Platform
- Windows
This was pulled from SmallBusiness website
To run a workbook without triggering a startup macro, you need to open it from within Excel, rather than double-clicking the file in Windows. Open Excel, go to the File menu, click "Open" and locate your file. Hold down the "Shift" key while you click "Open," and continue holding it until the workbook finishes
Edit:
lol, Micheal beat me to it
To run a workbook without triggering a startup macro, you need to open it from within Excel, rather than double-clicking the file in Windows. Open Excel, go to the File menu, click "Open" and locate your file. Hold down the "Shift" key while you click "Open," and continue holding it until the workbook finishes
Edit:
lol, Micheal beat me to it
Last edited:
Upvote
0
