Hi

I have a calendar with everyday from "Sunday 1 Jan 2006" To "Sunday 31
Dec 2006". I need to make a macro that when it is run it will change
the year from 2006 To 2007.

Another thing is that I want saturday and sunday to be marked(say
green) But when the year changes the dates are push forward so now it
is sunday and monday that is marked. How to make it auto mark saturnday
and sunday again?

It would be nice to have it all in one macro

thanks

San