Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a Window
A question about automatically closing some "popup" windows from VBA -
I'm importing data from another spreadsheet by selecting a range and then copying the range to the new spreadsheet (works fine, BTW). Then, I close the original spreadsheet and get two popup boxes: (1) Do you want to save changes? and (2) You have alot of data on the clipboard.... I got rid of having the first one popup by using the "Activeworkbook.close savechanges:= false" line. Any idea how to automatically close the second type of window? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
Closing a window after transferring data | Excel Discussion (Misc queries) | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Can I insert a pop up window in Excel to ask a ? b/4 closing? | Excel Discussion (Misc queries) |