Thread: month calendar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bedford Bob Bedford is offline
external usenet poster
 
Posts: 2
Default month calendar

Our boss asked us to fill a report every month where we set the time on
different projects (for billing purpose).

He gave us a template where they are lines with the projects and columns
with days. When a day is on the weekend, he must have grey background and no
calculation (time total).

As you can guess, the weekends changes every month, so every user copy the
existing previous month, and takes 15 minutes changing the report, removing
existing weekends and placing new ones.

Would it be possible, by setting the name of the sheet (say 1/2003) to
automatically fill this report to match the weekends of january 2003 ????

I'm new on Excel programming (I'm a Delphi programmer), so any code would
greately be appreciated.

Thanks in advance.

BoB