Monthly Event Schedule (format like that)

Originally Posted by mikerickson

The file has a link to EventsForDay.xlam, which I lack, but it looks like its not needed.

Hi Mike,

The file named EventsForDay.xlam is an addins to run UDF namly EventsForDay in Excel 2007. I forgot not to tell you this.

That file I created by copying your latest VBA code and pasted in VBA Module Editor of Excel 2007, and then saved it as an addins in order to create the UDF. I don't know if such is different from your Excel 2004 on Mac machine. In Excel 2003, it requires to do the same but the file name of the addins is EventsForDay.xla.

However, I find that your previously attached file already included VBA code that allows it to run in any machine without creating an addins in Excel to generate UDF named EventsForDay. So I try to do it like you did in the attached here.

Could you help me review and fix the problems in this file?

Thanks.