Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name of the sheet - hide and show
in previous versions of Excel it was possible to hide and show all names on
the low bar with just one command. This way we hided our customers names for other customers, when taking orders. It is very essential for us to do so. Any smart solutions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name of the sheet - hide and show
Possibly go to
Tools-Options-View, uncheck Sheet Tabs -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lars, Denmark" wrote: in previous versions of Excel it was possible to hide and show all names on the low bar with just one command. This way we hided our customers names for other customers, when taking orders. It is very essential for us to do so. Any smart solutions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name of the sheet - hide and show
All versions of Excel previous to 2007 have allowed you to disable the
display of all the sheet tabs under ToolsOptionsView Al versions of Excel have allowed you to hide certain sheets by FormatSheetHide...........you must have at least one sheet visible. You can group sheets to hide all at once but you must unhide them individually unless you run a macro. A couple of macro examples....................... Sub hide_some() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Name < ActiveSheet.Name Then ws.Visible = xlVeryHidden End If Next End Sub Sub unhide_all() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Visible = True Next End Sub Gord Dibben MS Excel MVP On Wed, 21 Jan 2009 10:27:02 -0800, Lars, Denmark wrote: in previous versions of Excel it was possible to hide and show all names on the low bar with just one command. This way we hided our customers names for other customers, when taking orders. It is very essential for us to do so. Any smart solutions. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name of the sheet - hide and show
Thanks for your answer - I use Excel 2007 and there is no such tab.
"Luke M" skrev: Possibly go to Tools-Options-View, uncheck Sheet Tabs -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lars, Denmark" wrote: in previous versions of Excel it was possible to hide and show all names on the low bar with just one command. This way we hided our customers names for other customers, when taking orders. It is very essential for us to do so. Any smart solutions. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name of the sheet - hide and show
Thank you for your answer - I hope MS will make this option possible again.
"Gord Dibben" skrev: All versions of Excel previous to 2007 have allowed you to disable the display of all the sheet tabs under ToolsOptionsView Al versions of Excel have allowed you to hide certain sheets by FormatSheetHide...........you must have at least one sheet visible. You can group sheets to hide all at once but you must unhide them individually unless you run a macro. A couple of macro examples....................... Sub hide_some() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Name < ActiveSheet.Name Then ws.Visible = xlVeryHidden End If Next End Sub Sub unhide_all() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Visible = True Next End Sub Gord Dibben MS Excel MVP On Wed, 21 Jan 2009 10:27:02 -0800, Lars, Denmark wrote: in previous versions of Excel it was possible to hide and show all names on the low bar with just one command. This way we hided our customers names for other customers, when taking orders. It is very essential for us to do so. Any smart solutions. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name of the sheet - hide and show
Lars
No version of Excel has allowed you unhide multiple sheets without using VBA Has never been an option. Gord On Wed, 21 Jan 2009 12:24:01 -0800, Lars, Denmark wrote: Thank you for your answer - I hope MS will make this option possible again. "Gord Dibben" skrev: All versions of Excel previous to 2007 have allowed you to disable the display of all the sheet tabs under ToolsOptionsView Al versions of Excel have allowed you to hide certain sheets by FormatSheetHide...........you must have at least one sheet visible. You can group sheets to hide all at once but you must unhide them individually unless you run a macro. A couple of macro examples....................... Sub hide_some() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Name < ActiveSheet.Name Then ws.Visible = xlVeryHidden End If Next End Sub Sub unhide_all() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Visible = True Next End Sub Gord Dibben MS Excel MVP On Wed, 21 Jan 2009 10:27:02 -0800, Lars, Denmark wrote: in previous versions of Excel it was possible to hide and show all names on the low bar with just one command. This way we hided our customers names for other customers, when taking orders. It is very essential for us to do so. Any smart solutions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show columns/cells in sheet but hide them in print? | Excel Discussion (Misc queries) | |||
Show/Hide series | Charts and Charting in Excel | |||
Hide n' show cells in protected sheet | Excel Worksheet Functions | |||
Showing + and - (show and hide) for rows in the sheet | Excel Worksheet Functions | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |