Making a vet calendar using Excel and VBA

This project makes use of Excel 2007 to provide a vet with a custom made calendar sheet that can always be printed out.
Contitional formatting indicates specal hours in the calendar or special holidays occuring during the year.
The VBA programming is used to printout the calendar for the 365 days in the year.

Settings sheet: Retaining and centralize the settings for the calendar used by different conditional formatting cells.

Settings Sheet Excel

Simple printout form: For printing one month recto-verso

Dialog form Simple Printing

Yearplanner sheet: An extra page with 12 month blocks using conditional formatting t indicate special dates defined in the settings sheet.

Year Planner sheet

Detailed printing form: To manually reprint a specific date range.

Detailed Printing Form

Detail Page: Thsi page is used by the vet to fill in several details, messages, operations that happened during that day.

Detailed sheet

Calendar sheet: This is the actual vet's calendar page per half hour.