| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting a response on a dialogue box from a Macro
What is the code to select a response on a dialogue box?
I have a Macro which saves the open work book to a couple of locations - in one of the locations it needs to be saved with the same file name each time. Obviously each time the macro runs, Excel opens a dialogue box asking "Are you sure you want to Save? - this file already exists" What code can I use to select the Yes button from the Macro? Cheers, Steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting a response on a dialogue box from a Macro
Try this.
Near the top of your macro, add the line: Application.DisplayAlerts = False then near the end of the macro, add the line: Application.DisplayAlerts = True "ChemicalJasper" wrote: What is the code to select a response on a dialogue box? I have a Macro which saves the open work book to a couple of locations - in one of the locations it needs to be saved with the same file name each time. Obviously each time the macro runs, Excel opens a dialogue box asking "Are you sure you want to Save? - this file already exists" What code can I use to select the Yes button from the Macro? Cheers, Steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting a response on a dialogue box from a Macro
Spot on! - Thanks very much!
RCW wrote: Try this. Near the top of your macro, add the line: Application.DisplayAlerts = False then near the end of the macro, add the line: Application.DisplayAlerts = True "ChemicalJasper" wrote: What is the code to select a response on a dialogue box? I have a Macro which saves the open work book to a couple of locations - in one of the locations it needs to be saved with the same file name each time. Obviously each time the macro runs, Excel opens a dialogue box asking "Are you sure you want to Save? - this file already exists" What code can I use to select the Yes button from the Macro? Cheers, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help (Uppercase multiple ranges?) | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Macro Help In Excel | Excel Discussion (Misc queries) | |||
| macro that brings user to cell based on "yes/no" response | Excel Discussion (Misc queries) | |||
| Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Hybrid Mode
