How to Unhide or Hide Multiple Sheets at One GO?

  • Thread starter Thread starter hce
  • Start date Start date
H

hce

Hi Everyone

I guess my Subject Title has already said what I need to know. SO is i
possible to hide or unhide a selection of worksheets at one go?

Cheers
Kelvi
 
Kelvin,

Select the sheets to hide, then Format>Sheet>Hide

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You can hide multiple sheets by just selecting (click on the tab for the first
and ctrl-click on subsequent tabs). Then Format|Sheet|Hide (or rightclick on
one of the selected tabs and choose Hide).

At least one sheet must be visible, though.

Unhiding them is one by one, unless you use some code.

Kind of like:

Option Explicit
Sub unhideAllSheets()

Dim wks As Worksheet

For Each wks In Worksheets
wks.Visible = xlSheetVisible
Next wks

End Sub
 
Back
Top