View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tony S.[_2_] Tony S.[_2_] is offline
external usenet poster
 
Posts: 60
Default Hide/Show some worksheets

Is there a way to use VB code to hide/show a group of worksheets at once,
possibly using a wildcard? I have a worksheet that contains many sheets that
need to be Veryhidden and Visible quickly and easily without having to go
thru the Format/Sheet/Hide menu. Each worksheet is named for a week of the
year. (i.e. (Wk 1) 12-1-2008, (Wk 2) 12-8-2008,(Wk 3) 12-15-2008 etc). The
current week will always be visible. Thanks!