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

On Wed, 05 Sep 2007 10:54:47 -0700, Ifatooki wrote:

On Sep 4, 2:44 pm, Gord Dibben <gorddibbATshawDOTca wrote:
"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



On Tue, 04 Sep 2007 14:36:17 -0700, Ifatooki wrote:
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?- Hide quoted text -

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