Block a sheet from being unhidden

F

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.
 
J

JP Ronse

Hi Fan,

Use VBA

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


Wkr,

JP
 
Top