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,

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

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

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

John's answer helps. Shift will stop the macro but it
will not allow you to edit it
-----Original Message-----
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

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




.