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]
More often than not software development seems to follow Henry Ford's comment on the Model T "You can have any color as long as it's black". Hence, the feature is available or not available.
Did you prefer the square command bars over the Ribbon; square buttons over round ones in the iPhone's dial pad, etc.? Tough luck ... you don't get to choose!
I guess it's much easier to roll-back the change than it is to come to a conclusion on where to present the setting: Ribbon or Options? If Ribbon: which tab?, which group?, which control type (button/checkbox/...)? If Options: which part (general or advanced)?, etc.
One exception to the "rule" above is the, by many, beloved dark mode. The thing that, all of a sudden, is a must-have. I don't know how we managed decades without it?
I liked having the lock icon show on the tab, it's easier to see which sheets are locked at a glance. Could the feature be activated/deactivated by the user in the options menu instead?
Glad to see it's been removed.
If some like it why not an option.
Can be just another option on the tab itself?
Richard Sterry commented
Thank you Steve. I appreciate your reply and explanation.
This needs to be available but as an option. I just was trying to audit some sheets that needed changes in formatting and was protecting the sheets that I was done with and relying on the lock to tell me which ones I had finished. It was unsuccessful as the lock is now gone.
I can see where some people would not like this feature, but I loved it (although it was a distraction when it first appeared). Making this a configurable option would give the best of both worlds.
Well we liked it...so how do we get it back...
Thank you Steve. I have Excel on my personal machine and one that I administer. I note that on both machines the lock has disappeared - looks more aesthetic.
I like the lock icon feature, as I often have to quickly look to see which sheets are protected.
Option for ON would be great.
I thought the lock was a great easy way to see which tabs were locked. Could it be provided as an option for those who would like to have it?
Thanks Steve this is very reassuring.
Just for the record, I think most users taking issue with the lock icons would be happy with a workbook-level option to turn them off, even if they're displayed by default in new workbooks. It's just not having the option which, in some spreadsheets, really hurts as it impacts usability.
Thanks again. M.
Robert Turner commented
Thanks Steve[Microsoft Excel] for actioning
Good decision. Thanks for replying.
I've reached out to a few of the engineers in the Excel team and one of them actually replied to me this week and said that the team is discussing this issue.
It's just very strange that they're not joining this discussion as the original feature change was put through based on a suggestion with only 10 votes and dozens of comments arguing against the suggestion.
Fingers crossed it at least becomes an optional feature soon...
Dave L commented
Feels like they are treating us like pond life.
Dave L commented
I tried the "send feedback" option already about a week ago. Same fantastic response that we are getting here.
Anders Ebro (TheSmileyCoder) commented
I suggest you use the "send Feedback" option from within excel. Maybe that will get more traction.
are we ever going to hear from Microsoft on this disaster? Those of you who use this forum often: does Microsoft EVERY respond to input from users? Or are we wasting our time here venting?
Maybe now that they lost Tik Tok they might make time for this. I would not hold my breath. The absolutely, and singularly lame codies at Microsoft still have not been able to fix the "account problem" issue after many, many years. The link below describes it well, however there are so many nuanced versions of Win10 that this does not work anyway.
In terms of customer response, Microsoft , you are as a group are an unmitigated joke, a farce. I emailed Satya from the email provided lower in the string, of course no hint of anything. Whatever, at this point for me. Best to all who still hold out hope. I will continue to tolerate MS for my OS for the moment, simply because I do not have time to re-invent the wheel. But my patience is wearing very very thin. Good luck to all who need this fix most. I think the MS techs actually do not likely not have the skillset to fix this problem that they created.
I'm assuming you were trying to get a human to read this thread by commenting including offensive words, but it looks like a bot has automatically asterisked them out... No win!
I'll try flagging your comment as inappropriate and see if a human replies to me so I can engage with them...
Crazy that we need to try these things to get heard!!!
Incredibly disappointing, and quite offensive, that nobody from Microsoft has even acknowledged this post, even as the votes approach 200 and there's clearly widespread support for this feature reversal.
Either they're not monitoring UserVoice, which is patronising to us as their users, or their selectively monitoring it and/or monitoring it and selectively listening, which is effectively just as bad.
If this radio silence continues I, like others in this post, will certainly never use UserVoice again and will be publicly critical of its existence as a bullsh*t PR stunt.
Pick up your game Microsoft.