unable to set the visible property of the worksheet class

[Aleciafxc]

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

 

[maheshi7145]

It works... Am Happy.. Thank u..

Sorry, I don't have any other suggestions. The error you get and the hide/unhide options for each sheet being greyed out both happen when the workbook structure is protected. I can't think of a different cause based on the information on the thread. I assume this is not an issue for all workbooks.

I know you've said that the workbook protection is not the problem, but just to be sure what happens if you run this code?

Sub UnHideSheets()
    Dim ws As Worksheet
    
    ActiveWorkbook.Unprotect "aaa"
    
    For Each ws In ActiveWorkbook.Worksheets
    
        ws.Visible = xlSheetVisible
    Next ws
    
End Sub

 

[astralfoxy]

Sorry, I don't have any other suggestions. The error you get and the hide/unhide options for each sheet being greyed out both happen when the workbook structure is protected. I can't think of a different cause based on the information on the thread. I assume this is not an issue for all workbooks.

I know you've said that the workbook protection is not the problem, but just to be sure what happens if you run this code?

Sub UnHideSheets()
    Dim ws As Worksheet
   
    ActiveWorkbook.Unprotect "aaa"
   
    For Each ws In ActiveWorkbook.Worksheets
   
        ws.Visible = xlSheetVisible
    Next ws
   
End Sub

I made an account just to thank you. You saved my life.

 

[dhimant]

Please Unprotect Workbook with Unprotect Structure & windows....(If you have protected)
Please see image
Then problem will be automatically resolved.
I have personally checked & verified this situation.

 

[mikesg]

SharePoint involving 2 people working on the same excel workbook can lead to corruption of the workbook.
That gave me that error message when I was running VBA code.
I rolled back, using SharePoint version history, to a good copy.