Thread: unhide sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default unhide sheets

Sure, there are a couple of ways. You could put the list of names into an
Array and loop through all your worksheets to Match their names against the
Array List. Or you could do a double loop by looping through each list name
and comparing it to all the sheet names by looping through them. Or you
could just loop through the worksheets and compare their names with a Match
to the range on sheet "Main".

Mike F
"Tom" wrote in message
...
Hi all,
Is it possible to have a list of sheet names in C8:C17 on sheet "Main",
and
have a macro that will UNHIDE those sheets that are listed in that range?
Essentially, I want to have all my sheets hidden until they are listed in
that range, then UNHIDE upon running the macro.

Thanks!