Macro Errors

[Jo Ann]

I have a newly developed tracking macro, which is accessed by several users within my department. Two of the users are experiencing errors when trying to use the macro

They successfully enter the password protected macro but when they attempt Data Input a Microsoft Forms window displays stating "Could not load an object because it is not available on this machine.

A Microsoft Visual Basic Compile Error then displays (I assume highlighting the visual basic error) "Can't find project or library. Highlighted: "Private Sub DTPicker2_CallbackKeyDown (ByVal KeyCode As Integer, ByVal . . .

Another Microsoft Visual Basic Error then runs: "This command will stop the debugger.", again highlighted "Private Sub DTPicker2_CallbackKeyDown (ByVal KeyCode As Integer, ByVal . . .

The macro developer does not seem to believe it's the programming, and our IS Dept. has not been able to resolve this issue for several months

Any feedback would be appreciated

 

[Dave Peterson]

You may want to go to a different calendar control--one you can distribute.

Ron de Bruin has some calendar control stuff at:
http://www.rondebruin.nl/calendar.htm
(the last line is a link to a free control, IIRC)