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]
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.
Michael Hutchens commented
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!!!
Michael Hutchens commented
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.
My thoughts are talk with your feet. If MS don't want to listen, don't waste your time giving expert opinion. Although I am following this thread, I certainly won't be bothering to contributing to any others.
It looks like this feature was requested here on uservoice and implemented on the strength of just 14 votes... there are currently 184 votes to remove it or make it optional, yet Microsoft don't seem to be listening!
Steven Hensley commented
tik tok tik tok Microsoft.
You really should have the decency to respond on this...........
Very rude at this point.
The current icon is extremely intrusive. And I'm having trouble imagining it being correspondingly important! How about changing some aspect of the tab's graphic presentation to indicate the sheet is protected? The active sheet is indicated by a bold bottom border on its tab. Perhaps for a protected sheet that bold underline could end with a tiny box (like the fill mode indicator for a cell) or perhaps half a TINY lock... Or the bold underline could be solid, if protected, or dashed, if not. Does one need to know whether an inactive sheet is protected? Not sure. It would be easy enough for the user to activate all sheets to review which sheets are protected and which aren't....
I agree, please remove the lock icon, or at least allow us to remove it if we want to.
We want a symbol but yes smaller is better
A dot ?
A vertical line ?
Please remove the lock "feature". It serves no purpose in my spreadsheets and only reduces the number of sheets that I can see the names of.
Remove the lock symbol... Remove it *now*
Nice of you to ad options in a program, but always make sure that the customer has the choice to turn Of/On the options
Please make it OPTIONAL, with OFF as the DEFAULT.
I'm happy with this feature, an option to turn it on or off in the workbook would be awesome.
BygAuld Byrd commented
Make the symbol OPTIONAL. DO NOT force a colour or other property. The Tabs are small enough now without effectively making them smaller.
Make it optional, possibly just with an optional tab background colour that does not take up additional space
Yes, as hgitz Guj said:
Make it OPTIONAL.
Make all new features OPTIONAL!!!