Losing copy after workbook change event

[hoffey]

When I have my workbook activate/deactivate events, it breaks my macro:

Please Login or Register  to view this content.

Doesn't allow the copied range to carry over:

Please Login or Register  to view this content.

Anyone know the best way to do this?

[romperstomper]

You could skip the activation:

Please Login or Register  to view this content.

otherwise with that sort of code, you need to use a dataobject to store the copied data, run your code, then put the data back in the clipboard.

Edit: Cross posted here too.