Can't use paste on one worksheet

[ADE2]

Hi

I know this might be difficult to answer,as there could be numerou
reasons.

I have a workbook with 7 worksheets, i can copy and paste on all th
Worksheets,except one.

I have checked that everything is selected that allows users to edi
worksheets(Tools/Protect Sheet)

Everything looks ok,my recent changes have included VLOOKU
formulas,Time formulas and a Worksheet Selection Change code(whic
works).

When i rightclick to copy i can do that but when i come to paste th
selection into a new cell,the paste and pastespecial are greyed out.


Any ideas as to what i might have messed up would be greatl
appreciated.

Ad

 

[ADE2]

I have solved the problem,i have deleted the Selection Change event an
will use another method to do the calculations i wanted

Thanks for the help

Ad

 

[jeff]

Hi, Ade.

My first thoughts are that the worksheet selection change
code may be holding up your paste. What is it doing?
Does it finish completely? Double-check it.

jeff

 

[Guest]

check that your worksheets are not grouped. If grouped,
right click sheet tab and ungroup