| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Clipboard Memory Saver
Hi All,
I have code that copies a range to another workbook. I then close it 'myfile.close false' but it brings up an alert that asks to save the clipboard info. set displayalerts to false, but now it takes for ever to continue after that point. Is there a setting or command to disable this clipboard feature? I NEVER want to remember what is on the clipboard. Thanks Chad |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Clipboard Memory Saver
Hi Chad,
Add the following line to your code ( after the paste line): Application.CutCopyMode = False --- Regards, Norman "CLS" wrote in message ... Hi All, I have code that copies a range to another workbook. I then close it 'myfile.close false' but it brings up an alert that asks to save the clipboard info. set displayalerts to false, but now it takes for ever to continue after that point. Is there a setting or command to disable this clipboard feature? I NEVER want to remember what is on the clipboard. Thanks Chad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear clipboard memory? | Excel Discussion (Misc queries) | |||
| Macro to disable screen saver | Excel Programming | |||
| Do you wish to clear clipboard memory? | Excel Programming | |||
| clearing memory /clipboard | Excel Programming | |||
| Dumping Clipboard Memory | Excel Programming | |||
Linear Mode
