in excel 2007 I have a spread sheet that has hidden sheets. I know all the passwords. To unhide sheets I'm supposed to right click on sheet name tabs on the bottom and click unhide. However the unhide option is greyed out.
the hide - unhide under Home > Format is also greyed out.
I have a password for the whole sheet, but I don't know where to enter it.
I hate excel 2007 ribbon structure.
Did you hide the sheets yourself or did someone else do it?
It's possible the sheets are "very hidden"; see this link for more information. You may have to use ALT+F11 to go into the Visual Basic Editor and change the sheet's Visible property.
I figured out the Answer and it is:
Ribbon > Review > Protect Workbook
Unclick - Protect Structure and Structure
Enter the password and the menu items are enabled
Thanks everyone for the assistance.