Macro to Convert an Excel worksheet into Very Hidden mode

Convert a worksheet to Very Hidden Sheet Mode

Sub VeryHiddenSheet()
Sheets("xlncad").Visible = xlVeryHidden
End Sub

Unhide a Very Hidden Sheet

Sub UnHideSheets()
Dim XLnCAD As Worksheet
For Each XLnCAD In ActiveWorkbook.Worksheets
XLnCAD.Visible = xlSheetVisible
End Sub

Leave a Reply

Your email address will not be published.Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.