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
--
Regards,
Nigel
"ryguy7272" wrote in message
...
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---
--
RyGuy