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]
For those having difficulties scrolling through the tabs, if you have a lot of tabs you can just right click between the 2 arrows in the bottom left corner and quickly change tabs. I'd like the padlock back as well, maybe an option would be the best solution here.
I liked the padlock. Please add as an option - that way if people want the padlock they can have it and if they don't then it won't show.
I liked it. Was very helpful.
Please bring it back as an option!
Matthew Gross commented
I am happy to see the icon go. I can see it being useful as part of the developer tab or in options. There are likely very specific people who want to have that view so I think optional status can a nice element. I can see it being useful in developing spreadsheets but once the spreadsheet goes to a basic user in a company, the user has no real need to know if a sheet is protected. Their main concern would be the ability to read tabs and use the workbook. When it was released, I had many employees calling in for support for a padlock image thinking the file was somehow being locked by maleware. It was just a little too much information for the wrong type of user.
Melanie Lee commented
I would also like it brought back...it was very helpful. Rather than going through each sheet to make sure it was locked, I was able to tell at a glance. Please make it an "option"
I found the lock symbols to be a great beneficial added feature with my work that I do in Excel. I just noticed on 9/17/2020 that it was gone and found this discussion from a 2018 discussion request to add the feature. Please add this feature back in Windows really soon, even if optional since some find it hard to have to scroll.
I understand the reduced space for tab titles, but I found the lock symbol beneficial. Please consider adding back as an optional setting.
Please add back the option for the lock symbol. It was really helpful to see that on each worksheet. It reduces the time to know which is protected vs. unprotected.
Please make the lock symbol a setting so that those who want to see it can and those who don't want to see don't have to.
Please bring the lock symbol back to the tab. Perhaps make it optional for those that don't want it. It was extremely useful for me.
I really liked the lock symbol because it helped remind me to lock sheets that are supposed to be locked. Now that this feature is gone, it becomes harder for me to monitor sheets protection again. So, please bring it back as an optional feature in future updates. Thanks!
Amy Ignatz commented
I liked the lock symbol so much because I am constantly unprotecting sheets, and the symbols remind me to protect them again before I save and exit. Please bring it back and make it optional for those who do or don't like it. Thanks.
I think it is a good idea to show the lock symbol, but appreciate it is not for all so giving the option to disable should be added. Not everyone uses 20+ sheets in a workbook
Anders Ebro (TheSmileyCoder) commented
Instead of checking each sheet manually, why not write a macro that does it for you?
Dim wsheet As Worksheet
For Each wsheet In ActiveWorkbook.Worksheets
You can put this macro in your personal workbook, if you'd rather not have macros in the workbook you have active.
Please put the lock symbol back!!!
It was so much easier to use when I had it and saved me time to check 200 sheets one by one.
bring the padlocks back as an option please.
I believe that relying on an indicator (such as the now removed padlock) could lead to false assurance about the status of a worksheet.
When you protect a worksheet you can permit the user to do none, some, or all of the following.
Select locked cells, Select unlocked cells, Format cells, Format columns, Format rows, Insert columns, Insert rows, Insert hyperlinks, Delete columns, Delete rows, Sort, Use AutoFilter, Use PivotTable reports, Edit objects, Edit scenarios.
The padlock gave no indication of the above.
The padlock gave no indication that most or perhaps all of the cells might have had their property set to be not locked in the event or the worksheet being protected.
I'm glad that it has gone.
For those that do want it back, despite its limitations described above, then make it an optional setting. Perhaps on the context menu for each sheet (like tab colour), or managed from the review part of the ribbon.
It could be a optional feature !!!.
Please bring back the padlock icon or add some way to visually notice that the sheet is protected.
I have always and will always tend toward "If it ain't broke..." But in the case of the lock on the tab, when I first noticed it, I really liked it.
This isn't a change that forces every user to retrain. The lock icon to me, is super and often can save me from breaking a sheet.
I am always modifying my workbook in the wake of changes or additional usages that arise. I finally quit locking all sheets. I leave future use sheets unlocked now and only lock the completed months/used sheets.
This allows future modifying of new sheets and protecting previous sheets which are now just references, without having to jump through hoops to see whether it's locked or not.
Let us turn the feature on or off or leave it on.
I would rather see it on by default though. If it bothers somebody (and obviously does), let them turn it off.