Clear clipboard

[Deer Hunter]

Hello,

I've got an worksheet from someone.
I had to unprotect the sheet.
And every time I go to another cell, it seems that the clipboard is cleared.
Not very handy, because when I want to copy a cell, move to the destination
cell, the clipboard is empty....
How can I change this? Somebody a solution?

regards, Mike

 

[Tom Ogilvy]

It sounds like the workbook has event code for the selectionchange event.
Right click on the sheet tab of the worksheet and select view code. See if
there is a selectionchange event in that code module. When a macro runs, it
often clears the clipboard and the undo history as a side effect.

Regards,
Tom Ogilvy