Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA command to say "yes"/"no" to popup window
Hi,
Does anyone know what VBA command I could insert into my Macro that would automatically select "yes" or "no" to an Excel pop-up window? So for example, I have a Macro which opens and closed workbooks and moves data from one workbook to another. In the process, I'll get an Excel window, which asks "do you want to save" (or something along those lines). I then click "No" and the Macro continues along its merry way. I was wondering if I could insert VBA code at that junction which would automatically select "No" to that prompt. Please advise. Thanks, Manuel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) |