It would be difficult. If performing an action causes an adverse situation,
then the work around is to avoid the action. In this case, I think you
might have to give something up. You are correct that many actions
performed by macros cause the clipboard to be cleared.

--
Regards,
Tom Ogilvy


"Andibevan" wrote in message
...
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