Various sheets are hidden and made visible through macros. Every once in a while sheets will be hidden and i cannot get them unhidden. When I right click on a sheet name the hide, unhide options are grayed out.
I have tried
Sub UnHideSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub
This does not work. When I attempt to access the sheet in the Developer and set its property to xlsheetvisable this error comes up
unable to set the visible property of the worksheet class
any help would be appreciated.
thanks
Alecia
I have tried
Sub UnHideSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub
This does not work. When I attempt to access the sheet in the Developer and set its property to xlsheetvisable this error comes up
unable to set the visible property of the worksheet class
any help would be appreciated.
thanks
Alecia