Forum Discussion
Solved
Lock Symbol On Excel Tab
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 ...
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.