Forum Discussion
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 no...
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 Sub
You 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
Thank you for explaining
, gave me a good laughing learning moment. Still getting an error, but different:
