Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/Unhide | Excel Discussion (Misc queries) | |||
hide/unhide | Excel Discussion (Misc queries) | |||
Hide Unhide | Excel Discussion (Misc queries) | |||
Hide/unhide | Excel Worksheet Functions | |||
Hide and unhide | Excel Discussion (Misc queries) |