paste greyed out

C

Cresta

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
 
M

Mike H

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
 
C

Cresta

All the cells are unprotected, can type ok.

Mike H said:
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
Click to expand...
 
C

Cresta

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
 
N

NickHK

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

NickHK
 
N

NickHK

Yes, but is selected when you try to Paste ?
If it is not a range (but a control or something else due the code in
Worksheet_SelectionChange), you will not be able to paste.

NickHK
 
C

Cresta

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.
 
Top