I have a spreadsheet that uses many macro's to do various things. I am getting complaints from users that they cannot copy and paste cells
from one worksheet to another.

I have macro's running on sheet activation. I know that this clears the undo history, does it also clear the clipboard (in the same way that if you copy a cell, then go to another one and type something in, you then have to go back and re-copy a cell before pasting)
I have though noticed that you can copy and paste from within the formula bar without being affected.

2 Questions if you don't mind.

1) Is my guess at why correct?
2) Is there a way round this (or is it so convoluted that it would be easier for me to tell the users to suck it up and accept this limitation)?

Thanks in advance for your help.