Hi All,

I am using the worksheet_activate and worksheet_deactivate events to turn on
and off Excels automatic calculation so that when I select "Sheet_1" it
turns calculate on and off when the sheet is deselected.

The problem is that using the events in this way appears to clear the
clipboard. As a result I am unable to manually paste data to Sheet_1.

How would I get around this?

I am using the application.calculation = xlManual to turn off and on
calculation.

Thanks in advance

Andi