Allow tab to be renamed when sheet is protected

[MarkSpencer]

Excel 2010. I have a workbook that has 12 copies of the same sheet. I have renamed the tabs 1-12. I have all the sheet protection working just fine. When I protect the sheet, it also protects the Tab Name. I want the users to be able to rename the tab to the last name of the person they are entering data for.

I didn't see any where in the options of what to allow the user to do, an option for "Rename" Sheet. Is this possible?

 

[Michael M]

It sounds like you also protected the workbook as well.
If sheets are protected, you can still rename sheets unless the workbook is also protected.

 

[MarkSpencer]

That's it! I was thinking I was password protecting the workbook, but that's a different step. THANK YOU!

 

[Michael M]

pleasure, glad to help...