Forum Discussion
kittenmeants
May 02, 2024Copper Contributor
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...
- May 02, 2024
One last question: Are you sure you have unprotected the workbook? This is what may be causing the issue.
MAngosto
May 02, 2024Iron Contributor
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"?
kittenmeants
May 02, 2024Copper Contributor
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.
- MAngostoMay 02, 2024Iron Contributor
One last question: Are you sure you have unprotected the workbook? This is what may be causing the issue.
- kittenmeantsMay 02, 2024Copper ContributorYep, 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.- MAngostoMay 02, 2024Iron Contributor