Hi Everyone!
I have this code to unhide all columns in a sheet that I need to run on the first 14 sheets of my workbooks. My workbooks have a total 16 or 17 sheets. Is there a way to run any code on the first 14 sheets at once or otherwise specify the names of those sheets that the code should not run into?
This is the code:
Sub Unhide_ColumnsRows_On_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Cells.EntireColumn.Hidden = False
ws.Cells.EntireRow.Hidden = False
Next ws
End Sub
If possible, I would like a solution that can work for the first 14 and that I can edit to work with the first 16 as well (some of my worksheets the code needs to run on the first 16 sheets), otherwise, as I mentioned before, one that specifies which sheets it should not run into.
Thanks!
I have this code to unhide all columns in a sheet that I need to run on the first 14 sheets of my workbooks. My workbooks have a total 16 or 17 sheets. Is there a way to run any code on the first 14 sheets at once or otherwise specify the names of those sheets that the code should not run into?
This is the code:
Sub Unhide_ColumnsRows_On_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Cells.EntireColumn.Hidden = False
ws.Cells.EntireRow.Hidden = False
Next ws
End Sub
If possible, I would like a solution that can work for the first 14 and that I can edit to work with the first 16 as well (some of my worksheets the code needs to run on the first 16 sheets), otherwise, as I mentioned before, one that specifies which sheets it should not run into.
Thanks!