Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |