View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steven
 
Posts: n/a
Default Opening up named worksheets according to the day of the month

Please help - Trying to write macro that would open up to a certained named
worksheet (1-31) based on the day of the current month. I have created a
formula =DAY(LEFT(NOW(),5)) that calaculates a value. Now I need it to
open up the corresponding named sheet.

Any help would be appreciated. TIA.