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