SOS! how do I run Excel without running the VBA in AUTO_OPEN?
in [General]
|
From: LunaMoon on 4 May 2010 09:27 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!
From: Luke M on 4 May 2010 09:41 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" <lunamoonmoon(a)gmail.com> wrote in message news:e44497a1-3a23-4d9d-bc76-14ef988f3952(a)v37g2000vbv.googlegroups.com... > 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! >
|
Pages: 1 Prev: SUMPRODUCT QUESTION?, Ratios Next: conditional format cells by date |