Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA empties clipboard
I have the following two events in my workbook to turn calculation on and off
when the workbook is activated and deactivated. Private Sub Workbook_Activate() Application.Calculation = xlCalculationManual End Sub Private Sub Workbook_Deactivate() Application.Calculation = xlCalculationAutomatic End Sub The problem is that this prevents users from copying from another Excel workbook and pasting into the one with the code. I am assuming it is because when the VBA fires, it is emptying the clipboard. Is there a way to make my workbook calculate manually, while leaving any other workbooks that are open calculate automatically, and be able to paste back and forth between workbooks? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
Office Clipboard empties itself when enabling/disabling commandbars | Excel Programming | |||
Transfer clipboard from Task pane clipboard(office?) content to Excel (windows?) clipboard? | Excel Programming | |||
Restore clipboard from Task pane clipboard content? | Excel Programming | |||
ClearContents or ClearFormats also clears Clipboard. How can I keep the clipboard? | Excel Programming |