View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] wisccal@googlemail.com is offline
external usenet poster
 
Posts: 51
Default How to Stop VBA from executing

Keep the shift button pressed when you open your workbook.

Regards,
Steve

Nigel schrieb:

Select disable macros on opening Excel.

If this does not appear open Excel and set security to medium, then close
Excel and open your problem workbook, then select disable macros.
--
Cheers
Nigel



"hon123456" wrote in message
ups.com...
Dear all,

I have write VBA Code to close a workbook when it was open.
Now when I open the workbook, the workbook will close immediately, thus
I cannot edit the VBA Code. How can stop the VBA code from executing
and then I can edit the VBA code.

Thanks.