Block a sheet from being unhidden

  • Thread starter Thread starter Fan924
  • Start date Start date
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.
 
Hi Fan,

Use VBA

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


Wkr,

JP
 
Back
Top