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]
Personally, I like it. I can understand turning the feature off when you have a large number of sheets but it is nice when there are only a few sheets. My vote is to include the feature but to be able to select whether you want it on or off... maybe have it off by default but with a quick settings change, you could turn it on if wanted. That would work for everyone.
Dave L commented
For me, don't like it, never will. But there is there is a strong minority that want it and a strong minority who don't. Most users probably don't care. So come on MS, re-enable it with "on/off" at workbook level and make everybody happy.
Personally, I do not use or need a lock symbol, but it seems a lot of people either like it or need it. What is the problem with making it optional? Ideally, the symbol should be unobtrusive, like an underscore. Or at best it could be user configurable.
Please bring it back. Many have commented that they need it over not. Make it an option for the ones who don't to turn it off. Please see these comment Excel Team and work on this request soon.
None Name commented
They were very useful - I understand the Real Estate Concern. What about a Highlighted DOT similar to conditional formatting but behind the text/name of the tab.
Also A suggestion around real estate might be to give the user a similar model to the windows task bar for "tabs", allow vertical, allow multiple horizontal rows - user determined
Can we please have the locks back?
They were very useful - saves a lot of time.
People hardly had a chance to get used to it being there before they were gone. The removal was far too swift, especially when you consider other requests and grumbles people have made (MDI, etc). if some people don't like it then introduce a setup option to give people a choice, don't just take them away, find a fix!
Please have a rethink.
this was actually very useful on some spreadsheets - although i agree unnecessary on others
why not make it an option in the right click menu so we can all choose whether we want this or not?
[Deleted User] commented
Very much liked this option and essential for me as I need to distribute Excel files so want a quick way of seeing that all tabs a locked.
It should be an optional setting in preferences. I loved it...
I really liked this option, because I prepare Excel files for colleagues, which I protect against editing certain cells per tab. Now I saw at once whether everything had been secured, now I have to keep looking back to info or per sheet. So please optionally return this option!
I don't see an option to vote to either (i) reinstate the locked icon on the worksheet tabs or (ii) have it as an option.
It looks like the only way to vote is to remove the locked icon.
For the limited time it was available, it was a significant time saver.
So I would like to vote to have it reinstated.
If it is available as an option - would someone please post where the setting is.
I thought this was a great idea and miss it now that you took it away./
Why don't you make this an option that a user can switch on or off?
It's a useful function.
I don't want it removed.
It's easy to tell the state of the sheets.
It's convenient to use.
I wish I could use it in the menu setting.
Tina Meadors commented
Please bring back the lock icon, or some other visual symbol of sheet protection. It was VERY helpful.
I would like to see the lock icon on the tab. It was a quick indicator to double check if sheets were locked/relocked.
Joshua Dela Cruz commented
Re-instate the lock icon, or add a toggle-able option on Excel PLEASE. Working at a home health agency that relies on having accurate spreadsheets at all times, not having that icon can actually lead to significant risk for our patients.
As the only scheduler for this agency, I need to maintain accurate and up-to-date admin-side records, which are kept in excel spreadsheets. If records of schedule adjustments aren't accurate, patients may end up not being seen. However, those records are changing constantly and rapidly, requiring constant upkeep over the course of a day - usually needing me to reference and update multiple sheets or workbooks at the same time.
Since the risk of accidentally deleting/typing over vital information is so significant, I really can't go without some kind of safeguard. My solution has been to use a macro hotkey that allows me to lock/relock a sheet whenever a change is made - it slows me down a tiny bit but is much safer than going without.
However, without that icon, I cannot tell if I've already locked a sheet without trying to type into it, forcing me to slowly test every sheet I update and sometimes even causing me to type over information while doing so.
I understand the rationale behind removing the icon, but please, please at least make it a toggleable option. It's a small thing, but it actually makes a real difference to us and our patients.
I would like to see the Lock icon on Sheets.
Adam BInns commented
I work every day with a workbook which has 102 sheets, all of which need to be protected to stop staff unintentionally editing the wrong cells. The padlock icon was incredibly useful to quickly see if a sheet was protected or not. Please please bring it back, even if it is only via an option.
Right click on the sheet "show protected sheet". It's important to have it!
Please bring back an option for the lock icon! It helped to ensure my documents are kept in tact as I could immediately see if the sheets were locked. I thought it was a brilliant visual idea.....