Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically respond to message box appearing within a VBA macro
Within a macro routine I am creating a .prn file and saving over an exisiting
file. Every morning this macro runs and a prompt appears asking if I am sure I want to overwrite the existing file. The user must click "Ok" in order for the routine to continue. Is there some syntax in which the macro will automatically answer the msg box? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I stop the EULA message appearing every time I start Excel? | Excel Discussion (Misc queries) | |||
toolbar automatically appearing | Excel Discussion (Misc queries) | |||
Error Message Appearing | Excel Discussion (Misc queries) | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) | |||
macro to respond to clipboard prompt? | Excel Programming |