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.
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.
One last question: Are you sure you have unprotected the workbook? This is what may be causing the issue.
- Yep, that was it. I was working between two similar workbooks and unhid one and not the other. Thank you so much for your help! I'm going to crawl in a hole now. haha....
But really, thank you so much. I really appreciate it.