Why would you be unable to rename an unprotected worksheet?
D Dave Peterson Aug 16, 2006 #2 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.
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 Aug 17, 2006 #3 The workbook is protected. Worksheet protection is for contents only, not for structure or re-naming. Gord Dibben MS Excel MVP
The workbook is protected. Worksheet protection is for contents only, not for structure or re-naming. Gord Dibben MS Excel MVP