Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear the copy
i have some code which i use to open another workbook, copy in some daa and then close it after but this creates a pop up asking if i wish t keep the data for pasting in later. Is there some code i can use t clear the copy without the pop up -- ceem ----------------------------------------------------------------------- ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065 View this thread: http://www.excelforum.com/showthread.php?threadid=54854 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear the copy
Hi Ceemo,
You could try Application.CutCopyMode = False, this I think clears it another alternative is to switch warnings off, ie Application.DisplayAlerts = False which would not prompt about clearing the data IF you use this method remember to switch it back on at the end of your code ie Application.DisplayAlerts = True. Cheers, James ceemo wrote: i have some code which i use to open another workbook, copy in some daat and then close it after but this creates a pop up asking if i wish to keep the data for pasting in later. Is there some code i can use to clear the copy without the pop up? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=548547 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear the copy
have you tried
application.cutcopymode = false before you close the workbook HTH Duncan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear and Copy vs Delete | Excel Discussion (Misc queries) | |||
Clear Clipboard after Copy | Excel Discussion (Misc queries) | |||
How clear the cut/copy blinking boxes after macro | Excel Worksheet Functions | |||
Copy and clear problem | Excel Programming | |||
clear, copy and paste | Excel Programming |