If you have the clipboard open when you copy from the other workbook the
item will make it onto the clipboard, you can then click the item to past
into the workbook with the code.

Not the best way but it will accomplisih what you're lookng for.

Tom

"jeffbert" wrote:

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?