The calendar control is an optional component that is actually part of
Access. So, unlike you, your European users may not have a version of
Office that includes Access or, if they do, their IT people may not have
installed the component.

--
Jim Rech
Excel MVP
"Kliu" wrote in message
...
| Hi -
|
| I have developed a macro that utilizes several user forms and a calendar
| control for users to input data. It works like a charm for users located
at
| US. However, the users located at Belgium are getting an error message,
| "can't find object". I am able to nail down on the calendar control
because
| the users are able to execute the macros, open some of the forms. Yet,
| whenever they are ready to click on the field that uses the calendar
control
| this message appears.
|
| My first reaction is to ensure the calendar control is turn on. The only
way
| I know is to go to the personal.xls file - Tool - VBE - Tools -
| References - click on Calendar control 9.0. However, my user at Belgium
| said he does not have personal.xls file, but has jhs2000.xla in his excel
| application holder.
|
| Are they the same file but with different name? Also, other ways to
resolve
| this problem? because for the users at the US, I did not do anthing with
| their set up and they are able to run this macro without any problem.
| Any advices greatly appreciate.
|
| Kathy