| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Respond to Excel message box from macro
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Respond to Excel message box from macro | Excel Programming | |||
| respond to message box | Excel Programming | |||
| user input into active excel macro- prompt - respond -insert-cont | Excel Programming | |||
| Automatically respond to message box appearing within a VBA macro | Excel Programming | |||
| macro to respond to clipboard prompt? | Excel Programming | |||
Linear Mode
