Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
Is it possible to respond to pop up messages with a macro? Im trying to respond to the two following pop ups, which are generated by activities carried out by the macro: 1. File already exists. Replace? Yes or No? (Im using the macro to save an updated version of an existing file). In this case, I would like the macro to respond with a YES 2. Large amount of data exists on clipboard. Do you want data to be available.......Yes or No? (Im using the macro to close a file which ive copied a large amount of data from.) In this case, I would like the macro to respond with a NO. In Macro Record mode, I responded to each message, but no code of anykind was copied into the macro. I dont want the user to be inconvenienced with having to respond to these messages. Thanks for any advice. Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Control Combo Box Macros | Excel Discussion (Misc queries) | |||
control form macros and protected sheets | Excel Discussion (Misc queries) | |||
How do I control where the input message appears? | Excel Discussion (Misc queries) | |||
Assigning Multiple Macros to One ComboBox Control | Excel Programming | |||
Assigning Multiple Macros to One ComboBox Control | Excel Programming |