You may have code running that has the unintended side-effect of clearing
the clipboard. Sheet activate or deactivate event code most likely or
that's my guess. The code is probably in the workbook in question but it
could be in another workbook or in an add-in. To look in the current
workbook right click the sheet's tab and pick View Code. If there is no
code look in the target sheet's code or the ThisWorkbook module.


--
Jim
"Graham H" wrote in message
...
An annoying problem seems to have developed in a workbook (Excel 2002)I
have and I am not sure how I arrived at it or how to sort it. I now cannot
seem able to paste any data between worksheets. If I copy form a worksheet
it goes into the clipboard. When I move to another worksheet and try to
paste it, the paste option is greyed out and CTRL-V doesn't work either. I
have no problems with any other workbooks,only the one but it is a bit of
a pest. Any suggestions would be most welcome.

Graham