Unable to paste in worksheet

[Ifatooki]

I have a worksheet that is not protected, however it will not allow
paste after copy, but i can paste into a new sheet. Any ideals as to
why this is happining and how i can fix it?

 

[Gord Dibben]

"will not allow" means what?

Nothing is pasted?

The cells are not accessible for pasting?

Do you get any error message(s)?


Gord Dibben MS Excel MVP

 

[Guest]

Maybe a macro is working behind the scenes.
Try to disable macros.
Tools | Macro |Security | Very high

 

[Ifatooki]

"will not allow" means what?

Nothing is pasted?

The cells are not accessible for pasting?

Do you get any error message(s)?

Gord Dibben MS Excel MVP





- Show quoted text -

Paste and Paste Special is grayed out for this worksheet. I can't
disable macros because the macros are needed for the worksheet to do
what it do, but when the macros are disabled the Paste options work
right.

 

[Gord Dibben]

Sounds like you have code that disables paste mode in that worksheet.

If that sheet is active can you copy from one cell to another on that sheet?

Does the gray-out just occur when you copy from another sheet then activate the
grayed-out sheet?

I would check for an event the disables paste in that sheet.

Either in Thisworkbook module or the sheet module.


Gord