SOLVED

Hidden sheets in excel workbook

New Contributor

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.


However, on a similar workbook if I right click in the tab area I can see hide/unhide but they are greyed out and I cannot work out how to be able to unhide the tab I require.

 

Can anyone help please.

 

Pete

2 Replies
best response confirmed by pottypetenb (New Contributor)
Solution

@pottypetenb 

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.

 

S0570.png

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