Why would you be unable to rename an unprotected worksheet?

D

Dave Peterson

It's not the worksheet protection that stops this.

It's the workbook protection.

Tools|Protection|protect workbook|checking structure
will stop insertion/deleting/renaming and moving of worksheets.
 
G

Gord Dibben

The workbook is protected.

Worksheet protection is for contents only, not for structure or re-naming.


Gord Dibben MS Excel MVP
 
Top