Macros Not Available?

[Bardess]

I have created an excel form for use in a small company setting. The form works beautifully for me, and i even sent it to a coworker, and it worked fine for him.

However when i open it on another computer at this company, and attempt to run the macros i created, i'm getting an error that reads: "could not load an object because it is not available on this machine".

Now, i created my macros so that they are saved in the workbook, not on the machine. They should work on any machine. We are running the same version of Excel (2007) and the only problem i expected to encounter was disabling the macros security.

When i open VB, i receive a 'compile error', stating 'Can't find project or library'. It also highlights the 'Private Sub UserForm_Initialize()' line of the following set of code:

Please Login or Register  to view this content.

I'm sure this is a simple solution to someone, but I cannot figure out why it's not working on this machine, but works on others? (This is not the only machine either, it's hit or miss amongst the 45 work stations within the company).

Any insight would be much appreciated!

[shg]

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

[Bardess]

Dangit! I tried to follow the rules, honest. All fixed now. I'm highly embarassed.

[shg]

Thanks.

I think the chances are that the calendar control is not installed on those systems. There are several thread on this topic in the forum -- see, for example, http://www.excelforum.com/excel-prog...nt-appear.html. Have a search and post back if you don't find what you need.

[Bardess]

The whole reason i wrote the macros was to avoid a calendar control not being available on various computers. I posted the last thread because the DT Picker i was using wasn't available on all computers. I was under the impression that my created macros would solve that issue. I have done a search of the forum to see if others have had this problem, and how it was solved, and haven't found any solutions.

Thanks so much for at least trying to help me out.

[shg]

So Calendar1 is a form you created?

[royUK]

For alternatives to the datePicker see the downloads here
http://excel-it.com/free_addins.htm

There'san addin, a date picker using comboboxes & a calendar form