Can't copy worksheet

R

rob nobel

I have a workbook where, if I right click ANY of the sheet tabs, I can't
copy the sheet.
Sheet Protection on/off makes no diff.
The book has no links other than by formulas within the book. However 1
sheet has no formulas at all.
I also cannot insert a worksheet to this workbook!
Can anyone tell me what conditions could cause this?
The problem is restricted only to this workbook.
Rob
 
G

Gord Dibben

Rob

Sounds like the Workbook Protection is "On"

Tools>Protection>UnProtect Workbook.

You may have to supply a password.

Gord Dibben Excel MVP
 
R

rob nobel

Thanks Gord and Rob, Didn't look there as I never use workbook protection.
I imagine it occured as it was a file that was first initiated by someone
else and sent to me.
Rob
 
Top