Forum Discussion
tiagolunardi
Jul 30, 2021Copper Contributor
My Excel file has hidden all tabs and is not possible to unhidden them.
After reboot my macbook a worksheet has hidden all tabs (This worksheet has at lest 15 tabs). I looked at the VBA and all tabs are there, but hidden. I've tried to unhidden choosing the option on Visible = 0 - xlSheetHidden to Visible = -1- xlSheetVisible. But when I change the option an error message apears: It's not possible to define the property Visible from Worksheet class.
I tried a macro with the following code:
Sub UnhideAllSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub
But it doesn't work.
Could you help me to unhidden my tabs?
Thanks in advance!
MacOS Big Sur 11.5.1
MS Excel for Mac (v. 16.51)
No RepliesBe the first to reply