SOLVED

Lock Symbol On Excel Tab

%3CLINGO-SUB%20id%3D%22lingo-sub-1520161%22%20slang%3D%22en-US%22%3ELock%20Symbol%20On%20Excel%20Tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520161%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20has%20been%20a%20recent%20change%20to%20excel%2C%20where%20if%20any%20of%20the%20cells%20are%20protected%2C%20a%20lock%20symbol%20is%20now%20shown%20on%20the%20corresponding%20tab%20at%20the%20bottom.%20Can%20we%20please%20have%20an%20option%20to%20remove%20this%20feature%3F%3C%2FP%3E%3CP%3EIt%20takes%20up%20way%20too%20much%20room%20across%20the%20width%20along%20the%20tabs%20at%20the%20bottom%20if%20every%20sheet%20has%20a%20protected%20cell.%20On%20a%20fresh%2Fblank%20excel%20file%20with%2025%20sheets%20you%20can%20nearly%20see%20all%2025%20sheets.%3C%2FP%3E%3CP%3EGo%20ahead%20and%20protect%20every%20sheet%2C%20and%20by%20the%20time%20you've%20done%20Sheet19%20you've%20lost%20sight%20of%20Sheet20%20(partial)%2C%2021%2C%2022%2C%2023%2C%2024%20and%2025.%20That's%2024%25%20of%20the%20tabs%20if%20you%20include%20Sheet20.%3C%2FP%3E%3CP%3ELike%20the%20old%20saying%20%22if%20it%20ain't%20broke%2C%20don't%20fix%20it%22.%3C%2FP%3E%3CP%3EBut%20please%20at%20the%20very%20least%20can%20we%20have%20the%20option%20to%20remove%20this%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank-you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1520161%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1520659%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20Symbol%20On%20Excel%20Tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520659%22%20slang%3D%22en-US%22%3EYou%20can%20vote%20for%20this%20suggestion%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F40858108-remove-the-lock-symbols-from-the-tabs-of-protected%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F40858108-remove-the-lock-symbols-from-the-tabs-of-protected%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1717557%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20Symbol%20On%20Excel%20Tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717557%22%20slang%3D%22en-US%22%3E%3CP%3EI%20like%20seeing%20the%20lock%20symbols%20because%20I%20have%20workbooks%20with%20many%20sheets%2C%20and%20the%20presence%20of%20the%20lock%20symbol%20enables%20me%20to%20quickly%20determine%20if%20all%20sheets%20are%20protected.%26nbsp%3B%20Otherwise%20I%20have%20to%20right-click%20every%20tab%20to%20see%20its%20status.%26nbsp%3B%20Making%20this%20an%20optional%20feature%20would%20satisfy%20both%20points%20of%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F727615%22%20target%3D%22_blank%22%3E%40Matt_Fielding%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1953604%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20Symbol%20On%20Excel%20Tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1953604%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F727615%22%20target%3D%22_blank%22%3E%40Matt_Fielding%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20agree%20the%20large%20lock%20takes%20a%20large%20amount%20of%20real%20estate%20on%20the%20screen%20but%20I%20believe%20I%20may%20have%20a%20solution.%26nbsp%3B%20Having%20a%20small%20colored%20dot%20on%20the%20tab%20showing%20say%2C%20a%20red%20dot%20showing%20locked%20and%20a%20green%20dot%20showing%20unlocked.%26nbsp%3B%20Also%20I%20would%20like%20to%20suggest%20a%20button%20on%20the%20tab%20ribbon%20area%20where%20you%20can%20lock%20or%20unlock%20all%20of%20the%20tabs%20using%20a%20checkbox%20pop%20up%20window%20with%20the%20tabs%20listed%20and%20a%20lock%20all%20or%20unlock%20all%20option%20as%20well.%26nbsp%3B%20Just%20an%20idea%20I%20believe%20will%20work%20and%20do%20this%20task%20efficiently.%26nbsp%3B%20I%20use%20several%20spreadsheets%20with%20multiple%20tabs%20where%20I%20have%20to%20unlock%20and%20subsequently%20lock%20the%20same%20tabs%20several%20times%20a%20day.%26nbsp%3B%20Spreadsheets%20with%2026%20tabs%20in%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2025042%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20Symbol%20On%20Excel%20Tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2025042%22%20slang%3D%22en-US%22%3EYes%2C%20with%20differing%20preferences%2C%20can%20the%20symbol%20please%20be%20restored%20as%20an%20option%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

There has been a recent change to excel, where if any of the cells are protected, a lock symbol is now shown on the corresponding tab at the bottom. Can we please have an option to remove this feature?

It takes up way too much room across the width along the tabs at the bottom if every sheet has a protected cell. On a fresh/blank excel file with 25 sheets you can nearly see all 25 sheets.

Go ahead and protect every sheet, and by the time you've done Sheet19 you've lost sight of Sheet20 (partial), 21, 22, 23, 24 and 25. That's 24% of the tabs if you include Sheet20.

Like the old saying "if it ain't broke, don't fix it".

But please at the very least can we have the option to remove this feature.

 

Thank-you.

4 Replies
best response confirmed by Matt_Fielding (Occasional Visitor)

I like seeing the lock symbols because I have workbooks with many sheets, and the presence of the lock symbol enables me to quickly determine if all sheets are protected.  Otherwise I have to right-click every tab to see its status.  Making this an optional feature would satisfy both points of view.

 

 @Matt_Fielding 

@Matt_Fielding

 

I agree the large lock takes a large amount of real estate on the screen but I believe I may have a solution.  Having a small colored dot on the tab showing say, a red dot showing locked and a green dot showing unlocked.  Also I would like to suggest a button on the tab ribbon area where you can lock or unlock all of the tabs using a checkbox pop up window with the tabs listed and a lock all or unlock all option as well.  Just an idea I believe will work and do this task efficiently.  I use several spreadsheets with multiple tabs where I have to unlock and subsequently lock the same tabs several times a day.  Spreadsheets with 26 tabs in them.

Yes, with differing preferences, can the symbol please be restored as an option?