Hi,

I have a sheet with a calendar control on a user form, just the calendar
control 11.0. This works fine, however when i distribute the sheet, the
users get an error message “could not load the object because it was not
valid on the machine”

When i save and open the sheet myself, i do not get the additional control
for the calendar control in my tool box, but the calendar control still works.

Can anyone advise.

Have you checked that the calendar control is available on the machine you're
distributing to?


"nathan_savidge" wrote:

> Hi,
>
> I have a sheet with a calendar control on a user form, just the calendar
> control 11.0. This works fine, however when i distribute the sheet, the
> users get an error message “could not load the object because it was not
> valid on the machine”
>
> When i save and open the sheet myself, i do not get the additional control
> for the calendar control in my tool box, but the calendar control still works.
>
> Can anyone advise.

He can not access the folder to check for mscal.ocx. I have re-written my
own instead.

Cheers

nathan.

"James Snell" wrote:

> Have you checked that the calendar control is available on the machine you're
> distributing to?
>
>
> "nathan_savidge" wrote:
>
> > Hi,
> >
> > I have a sheet with a calendar control on a user form, just the calendar
> > control 11.0. This works fine, however when i distribute the sheet, the
> > users get an error message “could not load the object because it was not
> > valid on the machine”
> >
> > When i save and open the sheet myself, i do not get the additional control
> > for the calendar control in my tool box, but the calendar control still works.
> >
> > Can anyone advise.