Name of the sheet - hide and show

  • Thread starter Thread starter Lars, Denmark
  • Start date Start date
L

Lars, Denmark

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.
 
All versions of Excel previous to 2007 have allowed you to disable the
display of all the sheet tabs under Tools>Options>View

Al versions of Excel have allowed you to hide certain sheets by
Format>Sheet>Hide...........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
 
Thanks for your answer - I use Excel 2007 and there is no such tab.

"Luke M" skrev:
 
Thank you for your answer - I hope MS will make this option possible again.

"Gord Dibben" skrev:
 
Lars

No version of Excel has allowed you unhide multiple sheets without using VBA

Has never been an option.


Gord
 
Back
Top