Can't copy worksheet

  • Thread starter Thread starter rob nobel
  • Start date Start date
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
 
Rob

Sounds like the Workbook Protection is "On"

Tools>Protection>UnProtect Workbook.

You may have to supply a password.

Gord Dibben Excel MVP
 
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
 
Back
Top