Ok.

Ctrl-M will get you a custom menu.

CalDates worksheet contains 2 columns of interest. Name and TODate. I have marked the Name with the string of the associated date cell. To test the worksheet,

1. Ctrl-M to show the menu
2. Select Mark Calendar with names. Each "Name" will be placed in the appropriate cell for Month and date.
3. Select "Clear all names from calendar" to clear them

4. Run the macro "CreateCalendar" to create a different year. It will clear everything and ask for the "year" Use the 4 digits year (i.e., 2006)

Ignore any misc test junk that might be floating around.

Please let me know any ideas you have.