Maco to Unhide Cols & Rows on all Sheets

[howard]

I have the following code below to unhide Cols & Rows on all sheets,

 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

However, when running the code, I get a run time error "unable to set the hidden property of the range class "

The code below is highlighted

    ws.Cells.EntireColumn.Hidden = False

It would be appreciated if someone could kindly amend my code

 

[pbornemeier]

I get that error if a sheet is protected. This took care of that problem:

 Sub Unhide_ColumnsRows_On_All_Sheets()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Worksheets
            ws.Unprotect
            ws.Cells.EntireColumn.Hidden = False
            ws.Cells.EntireRow.Hidden = False
    Next ws
End Sub

 

[howard]

Thanks for the help. Problem now resolved