Home

Help with worksheet name

%3CLINGO-SUB%20id%3D%22lingo-sub-823224%22%20slang%3D%22en-US%22%3EHelp%20with%20worksheet%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823224%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20workbook%20that%20is%20used%20by%20a%20lot%20of%20people%20and%20must%20be%20customizable.%26nbsp%3B%20I%20have%20left%20all%20editable%20cells%20unlocked%20so%20that%20each%20person%20can%20use%20the%20sheets%20for%20their%20separate%20events.%20%26nbsp%3B%20I%20want%20to%20be%20able%20to%20leave%20the%20worksheet%20names%20editable%20while%20having%20the%20workbook%20locked%20but%20I%20cant%20seem%20to%20figure%20out%20how%20to%20do%20this.%26nbsp%3B%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-823224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823288%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20worksheet%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823288%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398617%22%20target%3D%22_blank%22%3E%40nevasullivan%3C%2FA%3Eprotect%20the%20whole%20worksheet%20in%20the%20usual%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20Select%20the%20cells%20you%20want%20to%20unprotect%3C%2FP%3E%3CP%3E2)%20Right%20click%20-%20Format%20-%20Protection%20-%20Then%20uncheck%20the%20%22locked%22%20selection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823318%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20worksheet%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823318%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398630%22%20target%3D%22_blank%22%3E%40Holtender%3C%2FA%3EI%20need%20to%20leave%20the%20names%20of%20the%20different%20worksheets%20unprotected.%26nbsp%3B%20The%20named%20tabs%20at%20the%20bottom%20for%20each%20sheet.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
nevasullivan
New 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.