Forum Discussion
Solved
Hidden sheets in excel workbook
I have workbooks where I have hidden worksheets. On some I can right click in the tab area and then can see hide/unhide. I am then able to enter the password and unhide the relevant sheet. How...
If a workbook has been protected from the Review tab of the ribbon, you cannot hide or unhide sheets, and the context menu will look as in your second screenshot.
If a workbook has been protected from the Review tab of the ribbon, you cannot hide or unhide sheets, and the context menu will look as in your second screenshot.
- Dear Hans
You know I found this some while ago and for the life of me could not remember where to unprotect the sheet with the relevant password.
I have carried out that operation and low and behold it works.
Thank you so much I was getting a headache.
Peter
