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 time-being. 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.
We appreciate all the suggestions for alternative ways of indicating that a sheet is protected, and will take them into account.
Thanks for all your feedback.
Steve [Microsoft Excel]
Yes, please either remove this feature or devise a less obtrusive way of indicating a protected sheet (perhaps graying its name?). At any rate, make it optional.
Please make this unwanted feature optional!
Dave L commented
So in terms of number of votes, this dreadful "improvement" is number 54 out of 6890 ideas on UserVoice. I have to ask myself, is Microsoft so embarrassed about this they can't even make the effort to at least post a comment in spite of where it is in the ranking. Shame on you.
hgitz Guj commented
Make it OPTIONAL.
Make all new features OPTIONAL!!!
D give us the option to have it or not
R Budz commented
Seriously, are there any circumstances in which a sheet's protection status is more important than the sheet's name?
I cannot believe you've included this 'feature' before the one I submitted some time back. You'll wonder why it wasn't included for the very first Excel release.
Limit the background and font colors to only white.
This is such a great idea that it should be mandatory as well. Everyone will LOVE it!
Michael Hutchens commented
It's both frustrating and highly concerning that nobody at Microsoft has even acknowledged this thread. What is the purpose of having this UserVoice platform if suggestions with more than 156 votes and over 80 supporting comments are completely ignored?
It's even more astounding that the original feature suggestion was actioned/completed after receiving only 14 votes, even though it has 60 comments criticising the suggestion (https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/33239572-add-a-lock-symbol-on-the-protected-sheet-tab).
Microsoft - if you are at all monitoring UserVoice and have any respect for your most passionate users please join this conversation and let us know when we will be heard and this feature either removed or made optional.
Trying to change the way this ridiculous and unwanted feature can be applied suggest that it has some credibility among users. It need removing or at least have a way of disabling it.
Instead of the Lock some other device, such as underscoring or emboldening the First character of a Tab name, would be a good indicator. The name length need not be altered.
Who asked for this feature to be added? No one. Make it an optional thing in setup, or better yet...JUST YANK IT.
The underline would likely be a better solution. Then you don't have to worry about color schemes vs red and orange. Split the underline in half for partial lock, or coarse dotted. Full width line beneath for full lock. Equal line weight in both cases,just enough to be easy to see. Color could match the text color so it would be visible in the existing tab field, and not cause confusion. Or be an automatically generated offset color, but that might get confusing as well. I think match the text color. Then it is just a thin shape-icon below the tab text. and of course toggle off at user choice.
Robert M commented
Here's an idea about implementing the "Locked Sheet" or "Locked Portion of Sheet" - Change the color of the worksheet tab.
Normal is Background Grey. Active is Background White. Partial Locked is Background Light Orange. Locked Sheet is Background Light Red.
This allows the fullest amount of text on the tab.
Underlining was mentioned, but only allows 1 variation.
Ridiculous feature... totally unnecessary and should be removed.
Please remove this symbol 😭😭😭
Anders Ebro (TheSmileyCoder) commented
Remember that if you are unhappy with something you can use the "Send Feedback" feature from within excel to express your opinion as well.
Michael Hutchens commented
So I tried contacting Microsoft via 6 different channels about this, but all I received was auto-generated replies thanking me for my feedback. I even received one asking for my feedback on their replies, which was insanely frustrating. I did get a reply from Joseph McDaid (https://www.linkedin.com/in/josephmcdaid), who's a Principal Program Manager in the Microsoft Excel team, but only after I emailed Satya Nadella directly and mentioned my frustrations.
This issue really has to be actioned by Microsoft, so please help me keep driving this by:
The only reason more people haven't raised this issue is that it's taking time for large organisations to upgrade and see it.
I'm new to this site. Lock icon is really poorly implemented and not needed by the majority of users it seems. I nearly didn't bother making a comment as it appears a waste of time. Worse still, Microsoft doesn't even have the courtesy to respond to all these people who have taken time to comment. I won't be back, if they can't be bothered then why should I take time to make constructive comments!
Does anyone know if Microsoft actually reviews threads on uservoice or are we all shouting into a void?
I agree the lock icon takes up too much real estate, causes confusion/concern for my users, and should have an on/off option. I'm also perplexed by the rational of calling out sheets that are protected. As others have noted it draws undue attention to the sheet and most developers of custom Excel solutions don't want the fact the sheets are protected so blatently in their user's faces. Now some curious user is going to want to unlock the sheet to see what that does.
Microsoft, if you are listening (which by the radio silence on this thread, I doubt) please give the option to turn off the lock icon. Please.
Anders Ebro (TheSmileyCoder) commented
A big issue for me atleast is that the lock symbol does not properly reflect the fact that a sheet can be protected, but still be open for editing. E.g. most cells in our sheets are in fact open for editing, but we apply protecting to protect maybe 5% of the cells which need protection. But now with the symbol it looks like the whole sheet is locked.
My Autistic son finds the lock sign a barrier, he thinks it is good idea to be able to see if the worksheet is locked, at a glance, but he thinks it could be done with just an underscore on the worksheet Tab as an option. It does not need a lock symbol which takes up so much room.