Microsoft Calendar Control 11.0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryguy7272 - 05 Mar 2008 14:01 GMT

Some people in my office recently (re)started using an Excel model that was
used a long time ago. A guy who initially developed the model is not with
the company anymore. Some people have experienced trouble inputting
information into text boxes on the first UserForm that pops up (I personally
never experienced this problem). On the machines where there is an error, I
checked the VBA code and traced the problem to this: MISSING Microsoft
Calendar Control 11.0. So, I unchecked the box next to the library, and then
close the program and restart it and sometimes it works but sometimes it does
not work. How can I permanently disable this Microsoft Calendar Control
11.0? Or, how can I prevent it from repeatedly coming up on certain machines
in the office? I suspect there is a setting somewhere in Excel that would
allow me to disable this feature.

Regards,
Ryan---

Signature

RyGuy

Reply to this Message

Nigel - 05 Mar 2008 15:53 GMT

I guess you are using Excel 2003 or earlier? If so then the Calendar
Control v11 (mscal.ocx) was not supplied with the initial Excel
installation, and needs to be downloaded and installed on the target
machines. Excel 2007 has a version 12 loaded as standard.

Your simples option would be to remove the object from the UserForm, but you
probably will loose functionality. Consider downloading and installing the
calendar, reference here, but there are others..
http://www.fontstuff.com/mailbag/qvba01.htm

If you are using Excel 2007, then the calendar to reference is version 12
not version 11

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

> Some people in my office recently (re)started using an Excel model that
> was
[quoted text clipped - 17 lines]
> Regards,
> Ryan---

Reply to this Message

ryguy7272 - 05 Mar 2008 18:50 GMT

Thanks for the look Nigel. Actually, there is no calendar on the UserForm.
That's why I'm baffled. I had a reference to Calendar Control 11.0 in my
Excel. I unchecked the box, asked a colleague to open the model from the
network, and it worked. Maybe this will resolve the issue; time will tell.
I wish I knew more about this... Does anyone know what may cause this
behavior. Do you think some employees may not be getting critical updates
for MSOffice?

Thanks again,
Ryan--

Signature

RyGuy

> I guess you are using Excel 2003 or earlier? If so then the Calendar
> Control v11 (mscal.ocx) was not supplied with the initial Excel
[quoted text clipped - 30 lines]
> > Regards,
> > Ryan---

Reply to this Message

Nigel - 06 Mar 2008 07:46 GMT

That should resolve it. References will persist, even if you do not employ
them in your code, it is likely that the original developer set the
reference and did not reset it. If the object is referenced on a machine
with the mscal.ocx and it does not exist on the target machine or an out of
date version then you get the error you describe.

Critical updates for MSOffice is completely different, your IS department
should be controlling these.

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

> Thanks for the look Nigel. Actually, there is no calendar on the
> UserForm.
[quoted text clipped - 51 lines]
>> > Regards,
>> > Ryan---

Reply to this Message

ryguy7272 - 06 Mar 2008 14:39 GMT

Thanks for letting me know about this!

Regards,
Ryan--

Signature

RyGuy

> That should resolve it. References will persist, even if you do not employ
> them in your code, it is likely that the original developer set the
[quoted text clipped - 60 lines]
> >> > Regards,
> >> > Ryan---

Reply to this Message