Name of the sheet - hide and show

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

Gord Dibben

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
 
L

Lars, Denmark

Thanks for your answer - I use Excel 2007 and there is no such tab.

"Luke M" skrev:
 
L

Lars, Denmark

Thank you for your answer - I hope MS will make this option possible again.

"Gord Dibben" skrev:
 
G

Gord Dibben

Lars

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

Has never been an option.


Gord
 
Top