Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Calendar Control 11.0
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Calendar Control 11.0
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-- -- RyGuy "Nigel" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Calendar Control 11.0
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. -- Regards, Nigel "ryguy7272" wrote in message ... 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-- -- RyGuy "Nigel" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Calendar Control 11.0
Thanks for letting me know about this!
Regards, Ryan-- -- RyGuy "Nigel" wrote: 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. -- Regards, Nigel "ryguy7272" wrote in message ... 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-- -- RyGuy "Nigel" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Calendar Control French | Excel Programming | |||
Where can I get a copy of the Microsoft calendar control? | New Users to Excel | |||
Microsoft Calendar Control | Excel Programming | |||
Microsoft Calendar Control 10.0 | Excel Programming | |||
How to use Microsoft Calendar Control 9.0 on a Userform | Excel Programming |