Macro error for calendar functionality

[bigmantitus]

I am having issues with a calendar function that I have built into my Excel file (2007). In 2010 the macro OpenCalendar will not run and gets hung up on the frmCalendar.Show line of VBA code. It works fine in 2007. Did something change in 2010 that prevents it from working? If so, any thoughts on how to fix it? I have included the code for the calendar form. Any help is much appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[6StringJazzer]

Are you running this on the same machine upgraded from 2007 to 2010? Or on a different machine with 2010?
What controls are present on the form? Are there any non-built-in controls? What type of control is Calendar1?
What is the error message you get when execution stops?

There is nothing obvious in your code to cause a problem. If a form Show is causing an error I would investigate the form itself rather than the form's code, which didn't even get a chance to execute. It would be immensely helpful if you would attach your file.

[bigmantitus]

See if this works.

[6StringJazzer]

"Could not load an object because it is not available on this machine."

You evidently have a control on the form that is not installed on the machine where you are trying to run it. Copy the definition file for the control onto the machine. Then link a reference to it.

[bigmantitus]

Thanks for the response. Can you elaborate on your answer? The macro ran just fine in 2007 without any modification.

[6StringJazzer]

I ran your Sub that called Show on the form and immediately got the error that I listed. Upon trying to open your form I also got that error. The only control on the form was a Command Button, therefore there is another control that must be imported to be used.

It ran fine on 2007 once the control was installed. If you answer my initial questions from post #2 then we can explore further.

[Ouka]

I run into this all the time when supporting my old macro sheets. The MSCAL calendar control (from 2003 I believe) is no automatically installed in 2007 and 2013. You have to manually re-add it to your controls list on any machine that has the control but has since been upgraded. If it is a new excel install, you have to download the older MSCAL file and manually update your controls.

I get my control from here:

http://www.gmayor.com/downloads.htm