unable to edit macro!!!

[john]

i have two macro. One has the Sub Auto_open statement.
and the other has the application.quit before the end sub
statement. For some reason, i do not get the prompt to
enble or disable my macro. Since i added the application
quit, i have not be able to edit my macro. it process my
work correctly but i am unable to edit. any help? thanks

 

[John Wilson]

john,

Open Excel by itself (or any "other" workbook).
Tools/Macro/Security
Set to "Medium"
Now open the offending workbook and when prompted,
Disable Macros, then correct the code.

John

Set the

 

[Robin Hammond]

Or, in Explorer, I seem to recall you can hold down shift (or was it ctrl)
when you double click to open the workbook.

Robin Hammond
www.enhanceddatasystems.com

 

[Guest]

John's answer helps. Shift will stop the macro but it
will not allow you to edit it