There are several calendar add-ins created by Excel vba experts and availablefor free download. Why not begin with one of those? Here is one from MartinGreen's website (tutorial with downloads available):http://www.fontstuff.com/vba/vbatut07.htm