Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Clipboard Dialog Box during Macro
Hi All-
I have a vba program that runs through multiple iterations via a loop statement. After some point,from copying and pasting, the clipboard becomes full and a dialog box appears that asks if I want to save contents for another program or do I want to delete the contents. I have to hit the no button multiple times because it is looping through many iterations. I have tried using xlClipboard.Clear but I get an error that says I have an invalid qualifier. I have also used Application.CutCopyMode = False and it does not work. Any suggestions on how I can control the xlClipboard and set it so that it clears all contents on each loop. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to disable displaying clipboard within Excel? | Excel Discussion (Misc queries) | |||
How to disable "There is a large amount of data on the clipboard..." | Excel Discussion (Misc queries) | |||
Disable Query Refresh warning dialog box in Excel 2003 | Excel Discussion (Misc queries) | |||
allow user to disable annoying warning dialog on log charts | Charts and Charting in Excel | |||
How do you disable save file dialog? | Setting up and Configuration of Excel |