View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
u473 u473 is offline
external usenet poster
 
Posts: 184
Default Shade date headers, if Weekends or Holidays

Sheet1 with Column Date headers, for the next 18 Months.
Sheet2 with Holidays Dates in Column A
Questions :
1. How do I shade the headers with VBA for Weekends & Holidays ?
2. How do I, on Button-Click, Toggle Hide / Unhide the columns with
shaded headers
Thank you for your help,

Celeste