hide/unhide has vanished

[Keleigh-G]

I have several workbooks in which I had some sheets hidden. Now suddenly, I
am unable to unhide them. I am also unable to hide additional sheets.
The method I am used to is - select sheet, go to Format, Sheet, and
Hide/Unhide. But the Hide and Unhide options simply aren't there in the
drop-down menu any more. By looking at the properties I can see that the
hidden sheets are still in the workbook, but I just can't find any way to get
at them.

It's possible that my company's IT department changed our version of Excel.
I don't know how I could find out if they did though. Could that be the
source of the problem?

Any suggestions on how to make my hidden sheets come back would be
appreciated.

 

[Bernard Liengme]

If IT has given you Excel 2007 you would know - the GUI would look very
unfamiliar to you!
Is the workbook protected?
best wishes

 

[Mike H]

Do you mean literally vanished or greyed out?

Mike

 

[Luke M]

Ways to get it back:
Goto View->Toolbars->Customize. Under commands, look in the "Window and
Help" category. You can find buttons for Hide and Unhide.

OR

In VBA editor (right click on any sheet tab, view code), use this code:

Sub Unhider()
Sheets("SheetName").visible = True
End Sub

Change SheetName as appropriate.

 

[Gord Dibben]

It is possible you have protected the workbooks under
Tools>Protection>Protect Workbook and hide and unhide are just grayed out?

If hide and unhide are gone completely, I would suggest re-setting the
Worksheet Menu Bar.

Tools>Customize>Toolbars>Worksheet Menu Bar>Reset


Gord Dibben MS Excel MVP