Help with worksheet name

Copper Contributor

I have created a workbook that is used by a lot of people and must be customizable.  I have left all editable cells unlocked so that each person can use the sheets for their separate events.   I want to be able to leave the worksheet names editable while having the workbook locked but I cant seem to figure out how to do this.  Any suggestions?

2 Replies

@nevasullivanprotect the whole worksheet in the usual way.

 

1) Select the cells you want to unprotect

2) Right click - Format - Protection - Then uncheck the "locked" selection.

 

Hope this helps

@HoltenderI need to leave the names of the different worksheets unprotected.  The named tabs at the bottom for each sheet.