unable to edit macro!!!

J

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
 
J

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
 
G

Guest

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