Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SOS! how do I run Excel without running the VBA in AUTO_OPEN?
Hi all,
I am asking this for my friend. He has the following urgent problem. He put some VBA code into AUTO_OPEN (AUTO_RUN), basically it execute some other functions, and then automatically saves the closes out the Excel sheet. The problem now is that he wants to open that sheet to edit some stuff, now he's stuck -- whenever he opens the sheet, the sheet always auto- closes, and he had no way of operating it... What can he do? Is there a way to open a sheet without executing that AUTO_OPEN (AUTO_RUN) function? thanks a lot! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SOS! how do I run Excel without running the VBA in AUTO_OPEN?
Hold down the Shift key when opening to disable macros.
or Open a blank workbook, change macro security to High, then open the workbook. -- Best Regards, Luke M "LunaMoon" wrote in message ... Hi all, I am asking this for my friend. He has the following urgent problem. He put some VBA code into AUTO_OPEN (AUTO_RUN), basically it execute some other functions, and then automatically saves the closes out the Excel sheet. The problem now is that he wants to open that sheet to edit some stuff, now he's stuck -- whenever he opens the sheet, the sheet always auto- closes, and he had no way of operating it... What can he do? Is there a way to open a sheet without executing that AUTO_OPEN (AUTO_RUN) function? thanks a lot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass Auto_open Macro in Excel 2007 | Excel Discussion (Misc queries) | |||
AUTO_OPEN | Excel Discussion (Misc queries) | |||
Auto_open and more.... | New Users to Excel | |||
Help with 'Auto_Open' please... | Excel Discussion (Misc queries) | |||
auto_open? | Excel Discussion (Misc queries) |