Respond to Excel message box from macro

J

JackGombola

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro warning in word 1
Need Help with Macro Security 1
Excel freezing after sharing document by Email 0
Word OLE to check spelling in text box 1
Menu Macro Not Executing - Need Help 1
Excel keeps asking me if I want to save an already saved file. 0
Save workbook without shapes 0
Word macro that can call cells out of Excel for a find and replace 0

Top