Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipboard data at closure of a workbook
I copy lots of data from one workbook to another. When I
close the workbook from where the data is copied, I get a (pop-up) warning window that there is a lot of data on the clipboard with the question if it should be saved. In macro's I want to close workbooks; NO QUESTIONS ASKED. Does anyone know how to suspress this annoying question from Excel during the execution of macro's |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipboard data at closure of a workbook
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipboard data at closure of a workbook
After your paste line in your code use this line to clear the clipboard
Application.CutCopyMode = False -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl " wrote in message ... I copy lots of data from one workbook to another. When I close the workbook from where the data is copied, I get a (pop-up) warning window that there is a lot of data on the clipboard with the question if it should be saved. In macro's I want to close workbooks; NO QUESTIONS ASKED. Does anyone know how to suspress this annoying question from Excel during the execution of macro's |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need closure | New Users to Excel | |||
Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
Save document on closure | Excel Discussion (Misc queries) | |||
Unexpected closure of Excel | Links and Linking in Excel | |||
copy to the clipboard and into another workbook | Excel Discussion (Misc queries) |