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
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