Remove VeryHidden sheets from "File>Info>Protect Workbook" list in Backstage
Excel 2010 or later, goto Backstage: File>Info>Protect Workbook
Under Protect Workbook, it reads "One of more sheets in this workbook have been locked to prevent unwanted changes to data"
There is a list of protected sheets with Unprotect buttons next to them
VeryHidden sheets are included in the list. MS, why is that?
Keep VeryHidden sheets VERY hidden, so users are not aware of their existance, if VBA project is locked
Indeed! All I am arguing is that veryHidden, PROTECTED sheets should NOT be shown in this protection list
so isn't the workaround then to password protect your vba code which you want to do anyway or they can access the veryhidden via the VBA editor
That's why your sheets do not appear on the list. Only password protected sheets (Review tab) are listed, whether visible, hidden or veryHidden
Sorry, no, my macro's are password protected
Jan Wx - are your veryHidden sheets password protected?
I don't understand what you guys say I have just installed 2016 and it does NOT list my very hidden sheet. Where do you see this? It is not under
Info>Browser View options
and it is not under any of the Protect workbook options
Did you put a password protect on your VBA container?
This is an issue in Excel 2016 as well. I used the VeryHidden property to protect my intellectual property (IP), but yet any user can see the sheet name in the File > Info area. I did the development in Excel 2010, and later upgraded.
Since I use very hidden, I thought lets check. I use 2013, but do not find what you say under protect workbook. Is it a 2010 issue?
What is far worse is that if a sheet is very hidden and you have a range name pointing to a range on it, then the sheet name is known via Formulas > Use in Formula > Paste Names ...
With the sheet very hidden such range names should not display where they point to, because once you know the name, alll you have to do is create a sheet and create A1 = VeryHiddenSheetName!A1 and copy that across the sheet to see whats in VeryHiddenSheetName
Actually, no protected sheets should be in this list. The whole point of protection is to limit what the user can do to a sheet. To some, listing these as protected is almost a "break me" invitation.