From: LunaMoon on
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
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!
>