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.

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.

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.

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.

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.

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.