I have the same issue. I am running excel 2003 SP2 in XP. I have no
problems using the file, but others in the office get the compile error
message, however, on at least one user's machine, the "missing" reference
refers to a MS project calendar control.
Thanks

"tysop" wrote:

I'm trying to create an input form that contains a Date and time picker
(DTPicker) to be distributed to different versions of Excel. I am using
excel 2000, however when I open it in Excel XP I get the following error
message:
Compile Error
Can't find project or library

And in ToolsReferences I get Missing: Microsoft Windows Common
Controls-2.6.0(SP4)

Is there an easy alternative instead of the DTPicker or some code to fix this?
I don't have control over other users having any particular add-ins/updates
applied unfortunately, or even what version of Excel or what install options
were chosen.

Any help would be much appreciated.