View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Change tab colors via programming

I have created a calendar with separate sheets per week (so....52 sheets for
a year). I use conditional formatting to color the current day on the sheet
but I would like to color the tab as well. I want the current days' tab to
be yellow. I have tried several things but nothing works. Not sure where to
put the code (right click the tab and "View Code" I think, but not sure). I
want it to activate automatically.
Is this possible?
--
Bob R