Forum Discussion
Solved
Unhide Sheets: Can't unhide a xlSheetHidden
Hello! I have a workbook that was password protected (by me), I unprotected and now I cannot see my additional tabs. When I go to 'View Code' the tabs are there but unable to unhide.
They are not VERYHidden, so I don't know what the issue is. This level of excel is also new to me.
If I change xlSheetHidden to xlSheetVisible I get an error:
I tried code:
Sub UnhideTab() ActiveWindow.DisplayWorkbookTabs = True End Sub
Still nothing - again, not super comfortable with the code side so I might be doing something wrong, but it seemed pretty straight forward when I did a google walk-through.
I have 2 tabs that I need to unhide, the others are visible. Thank you!
One last question: Are you sure you have unprotected the workbook? This is what may be causing the issue.
Have you tried:
Sub UnhideSheet() Worksheets("Yourworksheetnamehere").Visible = True End SubYou need to change "Yourworksheetnamehere" with the actual worksheet name that you desire to unhide. If your hidden worksheet is named "Hello", you should write in the piece of code that I gave you:
Worksheets("Hello").Visible = True
