One other thing I've discovered ... when I first open the file, anytime I try to change an employee, I get an error message:

Unable to set the ColorIndex property of the Font class.

However, once I run the macro to clear the calendar, then I don't get that error message anymore.

Still having the same trouble with the colors.