Monthly Event Schedule (format like that)

**ExelFinder** · 07-21-2010, 08:26 PM

Originally Posted by mikerickson

Your attached file has more than 256 columns. This is causing my Excel 2004 to crash, could you please save a file in 2003 format and upload that file.

So sorry Mike. But this is my wanted file in Excel 2007.

I attach here the file in Excel 2003 format. After you solve the file in Excel 2003, please guide me how I add more columns when I convert this file into Excel 2007 to show more days of the year (Excel 2003 has only 256 colums to display about 251 days a year, while Excel 2007 can display up to more than 365 days a year).

Many thanks.

**mikerickson** · 07-21-2010, 10:01 PM

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

**ExelFinder** · 07-22-2010, 01:52 AM

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.

**mikerickson** · 07-22-2010, 05:00 AM

I think the attached will do what you want.
The function EventsForDay works with the named range DataRange.

Also, on MasterPlan! C1 there is a button, captioned "Create Sheets".
Pressing the button invokes a userform. Choose from the multi-select list of months and those sheets will be added to the workbook.

**ExelFinder** · 07-22-2010, 05:45 AM

Originally Posted by mikerickson

I think the attached will do what you want.
The function EventsForDay works with the named range DataRange.

Also, on MasterPlan! C1 there is a button, captioned "Create Sheets".
Pressing the button invokes a userform. Choose from the multi-select list of months and those sheets will be added to the workbook.

Wow, that works! Thank you so much Mike.

However, in the sheet February 2010 and so on, name of the days in row 2:2 do not appear, just a blank row.

Furthermore, if I delete sheet January 2010, and then creat it again there will be a problem with notice saying that Run-time error '9'. Or if I delete all monthly sheets, and then creat a sheet for any month, there will be a notice Run-time error too.

Again I am concerning about the limitation of columns in Excel 2003. In your file I can create a sheet for a month of next year (e.g. January 2011), but in the Master_Plan I only can make plan up to the date 09 Sep. 2010 (the last column is IV). Therefore, please help me convert this file to Excel 2007 with more colums to allows me to make plan till 31 Dec. 2010.

Hope you would continue helping me.

Many thanks.

**mikerickson** · 07-22-2010, 09:28 AM

This will should take care of those problems.
As for 2007, try saving it As in 2007 format.

**ExelFinder** · 07-22-2010, 12:25 PM

Originally Posted by mikerickson

This will should take care of those problems.
As for 2007, try saving it As in 2007 format.

Hi Mike,

I have no word to describe my sincerely and great thanks to your very patience and enthusiasm in helping me to solve my own problem.

Finally, I complete converting your file in to an Excel Marcro-Enable file that allows me add a numbers of colums to show more days of a year, while still keep your VBA code to run the file.

This forum is very great and helpful for me to meet admirable friends like you, whose kind-hearted support make us close despite a very far distance.

Many thanks again, Mike.

Best Wishes!