hide/unhide has vanished

K

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

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
 
L

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top