Block a sheet from being unhidden

[Fan924]

I was hiding a sheet and fooling myself that it was truly hidden. I
discovered that by going to
Format - Sheet - Unhide , the sheet is there on a list and can be
unhidden. Very sad. Is there a way to hide the sheet so it is not
visible on this list? TIA.

 

[JP Ronse]

Hi Fan,

Use VBA

sheets("sheetxxx").visible=xlveryhidden or use the properties for this sheet
to select this.


Wkr,

JP

 

[Fan924]

Thanks