This code will list hidden and very hidden sheets, which you might not want. When that’s the case, you’ll need to check the Visible properties xlSheetVisible and xlSheetVeryHidden.

How to Hide Columns and Rows in Excel . Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide.