SOS! how do I run Excel without running the VBA in AUTO_OPEN?

  • Thread starter Thread starter LunaMoon
  • Start date Start date
L

LunaMoon

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!
 
Hold down the Shift key when opening to disable macros.

or

Open a blank workbook, change macro security to High, then open the
workbook.
 
Back
Top