hi
at the beginning of the macro....
application.displayalerts = false
then at the end of the macro..
application.displayalerts = true

or turn the built in excel alert messages off then BEFORE exiting the macro
TURN them back on. (turning back on VERY important)

look up the displayalerts property in vb help.

regards
FSt1




"JackGombola" wrote:

I open and close Excel 2003 workbooks from within an Excel 2003 Ver 11 SP3
macro. I sometimes change the files but never want to save my changes.

What statements can I inlude in my macro code to:
1. Respond "Disable Macros" to the "Security Warning" message box that pops
up when I open the file and it contains macros?

2. Respond "No" to the "Do you want to save the changes you made to ..."
message box when I close the file?

Thanks in advance for any suggestions.

John