Remove the lock symbols from the tabs of protected sheets
Microsoft appears to have added this as a new 'feature' in Version 2006 (Build 13001.20266 Click-to-Run) and it's a disaster. For a workbook with a large number of protected sheets the visibility of sheet tabs is reduced by ~ 30%, thereby greatly reducing user-friendliness and the ability to navigate around the workbook using sheet tabs.
I've attached a screen grab of a basic model containing protected sheets which has lost visibility of at least 3 sheet tabs as a result of the unnecessary and unwanted lock symbols on almost every sheet.
This 'feature' needs to be removed or made optional and OFF by default.
Hi All, We apologize for being slow to engage on this thread. We are listening to your feedback and we really do care. After reading the comments here as well as the feedback sent from within Excel, we have decided to remove the lock icon from Excel on Windows for the timebeing. Since it’s not new to the other platforms (web, Mac and mobile) and we haven’t had similar feedback about it there, we won’t change those for now. We’ll consider how best to get consistency across the desktop, web, and mobile apps, and we’ll share updates if we have any additional next steps.
Since the lock icon was added recently, we can turn it off by using a configuration in O365, so you should notice that the change soon, without having to install an update. Just make sure to restart Excel.
Thanks for all your feedback.
Steve [Microsoft Excel]
Agree with OP 100%.
This feature is only needed by a few, please make it optional for the rest of us. It takes up far too much space on the tab, allowing only a few tabs to show across the bottom
Dave Sanders commented
This should have been optional in the first place!
PLEASE make this optional!!!
Brenda Lee Ray commented
PLEASE Make this feature OPTIONAL
Please make lock icon optional
Amy Greer commented
I can't have this symbol on worksheets I deliver to clients. I lock down which cells they can edit because they are not as Excel savvy as they think they are. Having this symbol on the worksheet tabs will freak them out, especially if I need to leave some unlocked and then some sheets have it and some don't.
Also, 100% agree with it taking up way too much real estate!
Please make this optional
It need removing. Complete waste of space. I have several workbooks with multiple tabs that fitted the screen. I now have to scroll across all of them. It hasn't been thought through. Stupid.
Henry Shonka commented
Add me to the list who thinks the addition of the lock symbol to the sheet tab is more annoying than useful, for all reasons previously stated. Please eliminate or at least make them optional with the default being off.
As many have said, this wastes a lot of space. End users don't need this to help them understand what they can and can't do on the worksheet. And as a developer, I definitely don't need it.
Richard Sterry commented
Please make it optional so it does not expand the width of the tab
PW Mercs commented
I understand the reason for it, but execution is poor.
At the very least make it optional.
Beyond that, convert it to a small overlay flag, like formula and comment flags on cells, anything that doesn't widen the tabs any further beyond the width of the sheet title. They've already been widened significantly since Office 2007, I still miss the tightness of the sheet tabs from that version.
I think the idea behind it OK as it probably saves a keystroke as you know you have un-protect before doing anything that will fail - but it's not practical as is - make it smaller, maybe a red corner like the green formula error indicator triangle so it doesn't take up any extra space plus optional.
Trent Kirkpatrick commented
It feels like MS wants to be overtaken by advanced data analytics platforms and dumb down Excel to exclusively a table builder. Why make a change so wholly obtrusive to your advanced user base for the benefit of the casual user and not make it optional?
REMON Gazal commented
Seriously annoying and unnecessary.
Dries Vermeulen commented
Give us the option to remove the lock symbol please!
Kevin Dommer commented
Add me to the list who thinks this is more annoying than useful, for all reasons previously stated.
As a frequent spreadsheet author, I do understand the usefulness of quickly knowing the protection status, particularly if you have been editing the workbook as it will help remind you that protection is currently off.
This said, as an alternative to simply making it optional, here are some ideas I think would be better:
1) Why not make it work similarly to when you have inconsistent neighboring formulas? So if ALL sheets are locked, no icon/indication is displayed. If some are locked and some aren't, then show indication.
2) For indication, going off the same idea in #1, why not just show a tiny colored triangle in the corner of the tab, similar to how a tiny triangle is displayed in the corner of a cell with an inconsistent formula (or a cell note)? Then when the user hovers over it, it can show locked/unlocked status. Maybe green for unlocked and red for locked? While it may still be distracting, at least it would not alter the size of the tab. As others have stated, these wider tabs result in fewer visible tabs in the same given window width.
MAKE IT OPTIONAL!!!!!
Alexandra Hildebrandt commented
I know I'm in the minority here, but I really like this feature. I'm working on a bunch of templates and I can forget whether or not I re-locked them. I only have three or four worksheets in each template, but there are 16 templates and they are used by 65+ divisions in our company. That's about 3,120 possibilities for me to forget to re-lock something after I've made a correction to a file.
I do agree with making it optional, but it's not a useless or annoying feature at all..