Why would you be unable to rename an unprotected worksheet?
 

Why would you be unable to rename an unprotected worksheet?

Why would you be unable to rename an unprotected worksheet?
 

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.



LBORDERS wrote:

Why would you be unable to rename an unprotected worksheet?

--

Dave Peterson

Why would you be unable to rename an unprotected worksheet?
 

The workbook is protected.

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


Gord Dibben MS Excel MVP

On Wed, 16 Aug 2006 15:12:02 -0700, LBORDERS
wrote:

Why would you be unable to rename an unprotected worksheet?