hide/unhide has vanished
 

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.

hide/unhide has vanished
 

If IT has given you Excel 2007 you would know - the GUI would look very
unfamiliar to you!
Is the workbook protected?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Keleigh-G" wrote in message
...
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.

hide/unhide has vanished
 

Do you mean literally vanished or greyed out?

Mike

"Keleigh-G" wrote:

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.

hide/unhide has vanished
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Keleigh-G" wrote:

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.

hide/unhide has vanished
 

It is possible you have protected the workbooks under
ToolsProtectionProtect 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.

ToolsCustomizeToolbarsWorksheet Menu BarReset


Gord Dibben MS Excel MVP


On Mon, 5 Jan 2009 09:06:11 -0800, Keleigh-G
wrote:

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.