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
"john" wrote in message
...
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