View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LunaMoon LunaMoon is offline
external usenet poster
 
Posts: 97
Default 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!