Sorted FYI

In the Worksheet_SelectionChange, the line "Me.cboTypeOfDeal.Visible =
False" is the cause of the paste options being greyed, I don't know why or
how to fix it leaving it in. So I have reworded the code and it works fine
now.

Thanks for you help anyway.



"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