Forum Discussion
Unhide Sheets: Can't unhide a xlSheetHidden
One last question: Are you sure you have unprotected the workbook? This is what may be causing the issue.
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:
Where are you writing the VBA Code? Try writing it on "ThisWorkbook" space:
Another question; If you sheet is not VERYHidden as you stated, why would you not be able to right-click on any visible sheet and then click on the option "Unhide"?
Just a quick walkthrough to make sure I am not missing something simple:
If I right click to unhide tabs, only 2 appear. There are 4 tabs total.
If I go to 'View Code', I can see my tabs/sheets for this workbook. The tab I am trying to unhide shows as "0-xlSheetHidden"
If I double click on "This Workbook", and enter the code, press Run, I still get an error.