Excel display VeryHidden worksheets in File menu?

[navic]

I have a Workbook that contains seven worksheets. When I click the "File" menu, Excel displays the protected VeryHidden worksheets that should not see the user workbook. I do not want to.
How to hide or not display the a look at VeryHidden protected worksheets in this situation. Is it in the settings of Excel or what?

Sheet1 (Sheet1)	- Visible protected
Sheet2 (A)	- Visible unprotected
Sheet3 (B)	- Visible unprotected
Sheet4 (C)	- Visible unprotected
Sheet5 (Chronology)	- Hidden unprotected
Sheet6 (D)	- VeryHidden protected
Sheet7 (E)	- VeryHidden protected

<tbody>
</tbody>

 

[shg]

The File menu?

 

[navic]

The File menu?

Yes, when I click on the "File". Please see the attached screenshot.

 

[Jonmo1]

Wow, interesting. I was able to replicate the behavior in Excel O365.

If the sheet is BOTH Protected AND VeryHidden, it's still visible in the menu when you click File.
It's only showing the name of the sheet, not any contents, and it's not like a link to the sheet or something.

This may in fact be an actual bug, shg?

 

[shg]

Office 365 -- curious.

I use Excel 2010, so no suggestion.

 

[navic]

It's only showing the name of the sheet, not any contents,...

Thank you guys for participating in these thread.
OK, but I do not want the user this Workbook, see any name VeryHidden worksheets ie. that they exist at all.
Is it possible to solve this problem?

btw: I use Excel 2013.
My regards for both

 

[navic]

Is it possible to solve this problem?

Someone MVP Excel