Are you selecting a control or object that cannot accept the Paste of a
copied cell(s) ?

NickHK

"Cresta" wrote in message
...
More info:
Open the file
Goto a different sheet first and copy a cell
Select problem sheet using tab, no cells selected yet, the paste controls
are available.
Click on a cell and the psate controls go grey
On the sheet the Worksheet_SelectionChange event runs when you click on a
cell (as expected), only changing the visibility of buttons and a dropdown
on
the sheet depending on the selected target.row/column .

Mmmm

"Mike H" wrote:

How sure are you that the sheet is unprotected?

Try and type something into a cell on the offending sheet and see what
happems.

Mike

"Cresta" wrote:

Hello
Excel cell cut and paste issue
The problem sheet has several buttons and dropdowns with associated
macros.
All sheets are protected/unprotected with a macro run from a custom
commandbar button. All custom controls work as expected. All other
sheets
work as expected.
The problem sheet allows a copy of a cell(s) but all its paste options
are
greyed out, including keyboard shortcuts. The copied value can be
pasted onto
a different sheet.
Any suggestions?
Ta