Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding and unhiding sheets
I want to know how to unhide multiple sheets. I know how to highlight and
hide multiple sheets, but how do you highlight more than one sheet to unhide it. Is that even posible |
#2
|
|||
|
|||
You'll need to use a macro.
Sub Macro1() For Each Sheet In Sheets On Error Resume Next Sheet.Visible = True Next End Sub If you need to know how to make the macro work get back to us. -- Greetings from New Zealand Bill K "D.Hay" wrote in message ... I want to know how to unhide multiple sheets. I know how to highlight and hide multiple sheets, but how do you highlight more than one sheet to unhide it. Is that even posible |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding and unhiding sheets
Bill,
This macro seems close to what I need. I post a question above wanting to hide/expose sheets based on a number either promted from a macro or entered into a cell. What I'm trying to do is only show the number of technician sheets needed for a location. THe workbook comes with 50 technician sheets, but most locations have less than 10. I don't want all 50 worksheets to show. I want to ask the question, how many techs to you have, only display those number of worksheets and hide the rest. Can you give me any help? Thanks! "Bill Kuunders" wrote: You'll need to use a macro. Sub Macro1() For Each Sheet In Sheets On Error Resume Next Sheet.Visible = True Next End Sub If you need to know how to make the macro work get back to us. -- Greetings from New Zealand Bill K "D.Hay" wrote in message ... I want to know how to unhide multiple sheets. I know how to highlight and hide multiple sheets, but how do you highlight more than one sheet to unhide it. Is that even posible |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|