| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
office clipboard
Is there a way to clear the office clipboard using VBA. I am making some
large copies in a macro and it eventually freezes my system. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
office clipboard
Larry
Application.CutCopyMode = False clears the clipboard. Plunk it into your macro after your paste code. Gord Dibben MS Excel MVP On Thu, 15 Mar 2007 11:03:18 -0700, Larry wrote: Is there a way to clear the office clipboard using VBA. I am making some large copies in a macro and it eventually freezes my system. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
office clipboard
Thanks for your reply. I have tried that and it isn't clearing the
clipboard. Could I have sometning in the setup that prevents this. "Gord Dibben" wrote: Larry Application.CutCopyMode = False clears the clipboard. Plunk it into your macro after your paste code. Gord Dibben MS Excel MVP On Thu, 15 Mar 2007 11:03:18 -0700, Larry wrote: Is there a way to clear the office clipboard using VBA. I am making some large copies in a macro and it eventually freezes my system. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
office clipboard
Larry
If you're still there, try this...... Sub ClearClipboard() OpenClipboard 0& EmptyClipboard CloseClipboard End Sub Gord On Thu, 15 Mar 2007 18:09:00 -0700, Larry wrote: Thanks for your reply. I have tried that and it isn't clearing the clipboard. Could I have sometning in the setup that prevents this. "Gord Dibben" wrote: Larry Application.CutCopyMode = False clears the clipboard. Plunk it into your macro after your paste code. Gord Dibben MS Excel MVP On Thu, 15 Mar 2007 11:03:18 -0700, Larry wrote: Is there a way to clear the office clipboard using VBA. I am making some large copies in a macro and it eventually freezes my system. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't paste from the office clipboard | Excel Discussion (Misc queries) | |||
| Office Clipboard | Excel Discussion (Misc queries) | |||
| Office 2000 clipboard | Excel Discussion (Misc queries) | |||
| Office Clipboard | Excel Discussion (Misc queries) | |||
| Is there a way keep the office clipboard from returning? | Setting up and Configuration of Excel | |||
Linear Mode
