Add a lock symbol on the protected sheet tab
A small lock symbol on the protected sheet tab would be a little addition but visually important!
Hi – due to concerns expressed by people who did not like the way the lock symbol was added to protected sheets, we will stop showing it on sheet tabs in Excel for Windows for the time-being. We may bring it back in the future in some other fashion.
If you’d like to see a lock symbol or some other visual indicator when a sheet is protected, please add your vote and comment here.
Here’s the related discussion – https://excel.uservoice.com/forums/304921/suggestions/40858108
Many Thanks – Steve [Microsoft Excel]
Kevin - chill, buddy. This request was about what I was seeing on my end in October 2019, which I confirmed to be WAD with MS Support at the time, and I simply showed you that the feature isn't appearing universally which could help you debug your own situation.
Like I said, I agree that this feature should be optional, and I sympathize with people that are now seeing padlocks they don't want to see. I'm simply providing you with additional information - a screenshot to show you that your experience is not universal, and the version of my Excel client so you can compare with your own.
Not sure where your head is stuck, nor why you would think I or any other 2016 user had anything to do with padlocks that we don't want appearing . Do your homework with MS if you have contact. I do not. I am not here to debate the facts, simply share them accurately. Your screen shots won't help anyone who raised the issue at this end, and who actually do have the unwanted issue. Microsoft issuing a fix will help. That is all I really care about. So if someone from Microsoft could please respond on this, I would appreciate it.Then you and I will not need to communicate.
Kevin - it seems we are not having the same experience with Office 2016. My entire team uses Excel 2016, and the whole reason for this request was that the two (Excel 2016 and Excel Online) were not identical, and still are not as far as I can tell. Despite the tabs being locked, with padlocks visible in Excel Online, those same spreadsheets do not have padlocks when opened in Excel 2016. I brought this to the attention of MS support, and they recommended posting a feature request here.
This may be a testament to your general complaints about the quality of MS products and I am not disagreeing with you that they could do a better job, I am simply noting that I put the request in specifically because there was a feature in the online version that I wanted to see added to the offline version, and as far as I can tell that has not happened. Frankly if you are seeing padlocks on your excel sheets in Excel 2016 my accounting team would love to know how you managed it. I'm using Excel 16.0.5026.1000 and I've attached a screenshot (left is Excel 2016, right is Excel Online).
Rich I believe that the posters all use desktop-only Excel ( at least I do) and have never used the online version. The comment about the lock icon already existing in the online version is irrelevant in this particular conversation, except that it appears that your request was in fact specific to standard version, otherwise why make the comment? The padlocks did in fact show up in standard Excel about the time of the first posts on this thread , and as I stated, In my case on 2 machines first, then on another machine( this one). The issue is that this change has no visible or findable way to revert to the old icon view, without the lock image. This machine is a very new 2020 Win10 machine, and all 3 are within the past 2 years. I am using Excel 2016 because it is the last version available that the user has had some control over up until now, as opposed to Office 365. I think it is pretty clear that all the posting users simply need a way of turning off the newly inserted lock icon feature. So not sure why you would not be experiencing this occurrence on your desktop iteration, especially after specifically requesting in. Perhaps just not yet. As an aside, I know many many MS users who have complained about the fact that Win10 generates ongoing false "account problem" notifications. On a daily basis. Usually a "password issue". I simply click past that and it is not an issue. Outlook works fine on at least one box, and I do not use it as my main email client anyway, so this does not cause me a problem. My point with this last comment is that Microsoft is largely incompetent regarding certain software function and detail, and service to customer in many areas, as I have requested and even called in to find a fix for the supposed password problem, finally giving up and going to the click-past solution. I have spoken to a half-dozen business users who have the exact same issue , also on fully legal and paid up versions Microsoft software. So, the posting group does in fact have a valid point, and we will see where this lands and how long a fix takes to be issued (if it even will be) At some point, when I can do what I need to on another piece of non-MS software, I will vote with my feet. At the moment I am just adequately functional although annoyed with Excel and MS both. When it eats too much time, I am gone.
Dave Sanders commented
Please make this OPTIONAL!
Rich (original poster) commented
A number of people responding to this request seem to have not noticed this in the original request:
"The padlock icon already exists for worksheet tabs on Excel Online".
As far as I can tell MS has not made any changes related to this request; the desktop version I am using still does not have any padlocks.
I'd also prefer it to be an option, btw.
Microsoft reasoning is really amazing. A Suggestion with a couple of votes is implemented, while others with hundreds or thousands of votes are simply ignored for years. Of course if somebody likes this, or really wants this, I don't see any problem to have this as an OPTION.
But Imposing this to the millions who don't need it, and don't want it, having impact on millions of running applications is ... really stupid. Its like setting the default Cell format to currency for everybody around the world.
MS: Please make this an OPTION, not at the application level, but at Workbook level, and keep the default as before.
PW Mercs commented
I totally understand the reasoning for this, but the execution of this idea is extremely poor.
At the very least, this needs to be OPTIONAL.
Further to that, it should be a smaller overlay icon/flag, similar to the formula and comment flags that appear on cells—anything that doesn't further widen the sheet tab beyond the width of the text. Already the sheet tabs have been widened significantly since Office 2007. I miss the tightness they had in that version.
I have added a submission to Microsoft from the Feedback window within Excel itself on one of my machines, and encourage all users who need control over this new and annoying feature to keep submitting additional input to Microsoft. I also DO expect a response from Microsoft from both my personal submissions, and also the total contents of all submissions on this web page, which I have not had yet. I recommend that whomever at Microsoft runs this page do their job and respond on this important issue, to at least update all commenting Excel users on the coming fix for this newly created problem. We will see how the response goes, or if higher-level input is required. It certainly will be forthcoming, forcefully and away from this page. Thank you in advance for your help with fixing this new user problem which the coders have created by their decisions and actions, which unfortunately is affecting all of us daily users of this Microsoft product. I have spoken with other local users and they also say the same thing.
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..
You can vote against this suggestion here:
Awful awful awful. Please make this optional.
And for the sake of your business itself.
MICROSOFT CODIES. We evidently REALLY do not like the feature. We need control over it. I have spent a lot of dollars on your software over the years, as I am sure have many of the folks below . You need to listen to us act on this, not just one person's request for the feature. Please actually listen and fix the problem you have now created. We are getting sick of the way you do these updates out of the blue with no user control. This is a particularly bad one. As are the "new" extra over stamps causing new clutter on the actual main Excel file icons. Who asked for those or needs them? Everyone is being way too nice about this. Fix the lock image problem please. Do your real job. This is about multiple users, not individuals. Thank you. I am being polite here. Regardless of the email I am using with Microsoft, I have been using Excel and paying for it since mid-1980s. So please listen to us about this serious problem which you have created with no user solution shown. Please fix it right away, for your paying customers' sake. Thank you.
Once again, Microsoft thinks we need cute little things for "children that cannot think good" and forget that, maybe to their own surprise, excel is still used by productive professional adults.
The symbol is so preposterous that seems planned to **** people off.
Get rid of the freaking cow bell immediately.
MAKE THIS OPTIONAL!
Get rid of this or at least let me turn it off!!!!
I agree. This is truly awful. They are ugly, cluttered, useless and consume way too much valuable space.
Ideally it should be removed completely. If made optional then I think that the option should be under the control of the Spreadsheets AUTHOR rather than the End-User.
David Horan commented
The Lock Icon on the Sheet Tabs is a disaster!! I have several excel templates set up for use across our company. They are all designed to fit on a single touch screen - now they don't! Having to remove PPE to scroll one sheet has resulted in a production loss of 1/2 - 3/4 hr per person per day!