paste greyed out
 

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

paste greyed out
 

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

paste greyed out
 

All the cells are unprotected, can type ok.

"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

paste greyed out
 

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

paste greyed out
 

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

paste greyed out
 

I am trying to paste into a cell. Nothing special.

"NickHK" wrote:

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

paste greyed out
 

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

"Cresta" wrote in message
...
I am trying to paste into a cell. Nothing special.

"NickHK" wrote:

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

paste greyed out
 

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