Aug 26 2019 11:20 AM
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?
Aug 26 2019 11:46 AM
@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
Aug 26 2019 11:58 AM
@HoltenderI need to leave the names of the different worksheets unprotected. The named tabs at the bottom for each sheet.