Calendar control doesn't work on some machines

Hi

I have installed the Excel calendar on an Excel worksheet where it works
fine, however when the same worksheet is distributed to other users this
control either doesn't come up at all, or it comes up but without the
calendar dates being visible.

The worksheet is not protected, nor does it have any merged cells on it.

Can anyone tell me the cause of the problem and how to cure it?

In your workbook VBA add a reference to the Microsoft Calendar Object x.0.
Tools\References and put a check next to the reference. Save your book and
re-distribute. I believe the calendar object is activated on the machine
from Access and if that machine did not install Access than it does not know
what the object is yet. By using a reference to it in your book, the other
machines will know how to use the object.

Mike F
"Geoff" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> I have installed the Excel calendar on an Excel worksheet where it works
> fine, however when the same worksheet is distributed to other users this
> control either doesn't come up at all, or it comes up but without the
> calendar dates being visible.
>
> The worksheet is not protected, nor does it have any merged cells on it.
>
> Can anyone tell me the cause of the problem and how to cure it?

Thanks for the information Mike, but I have already checked the Microsoft
Calendar Control 11.0 under Tools/References in my workbook. The problem is
possibly occuring on machines without Access installed. Is there any other
way of circumventing this - maybe by the use of code?

"Mike Fogleman" wrote:

> In your workbook VBA add a reference to the Microsoft Calendar Object x.0.
> Tools\References and put a check next to the reference. Save your book and
> re-distribute. I believe the calendar object is activated on the machine
> from Access and if that machine did not install Access than it does not know
> what the object is yet. By using a reference to it in your book, the other
> machines will know how to use the object.
>
> Mike F
> "Geoff" <[email protected]> wrote in message
> news:[email protected]...
> > Hi
> >
> > I have installed the Excel calendar on an Excel worksheet where it works
> > fine, however when the same worksheet is distributed to other users this
> > control either doesn't come up at all, or it comes up but without the
> > calendar dates being visible.
> >
> > The worksheet is not protected, nor does it have any merged cells on it.
> >
> > Can anyone tell me the cause of the problem and how to cure it?
>
>
>

NOTE: The Calendar Control is an ActiveX control (actually a file called
mscal.ocx) supplied with Microsoft Office. It is normally installed with a
standard installation of Microsoft Office Professional or Microsoft Access,
but if you can't find it on the list you will need to get hold of a copy. If
you are distributing your file, or planning to use it on more than one
computer, you will also need to make sure that the host computer has the
mscal.ocx file installed. You will find it on the CD that your copy of
Microsoft Office Professional came on, or you can download a copy from here.

[Follow this link for full instructions on downloading and installing the
mscal.ocx ActiveX Calendar Control file.]



Mike F

"Geoff" <[email protected]> wrote in message
news:[email protected]...
> Thanks for the information Mike, but I have already checked the Microsoft
> Calendar Control 11.0 under Tools/References in my workbook. The problem
> is
> possibly occuring on machines without Access installed. Is there any other
> way of circumventing this - maybe by the use of code?
>
> "Mike Fogleman" wrote:
>
>> In your workbook VBA add a reference to the Microsoft Calendar Object
>> x.0.
>> Tools\References and put a check next to the reference. Save your book
>> and
>> re-distribute. I believe the calendar object is activated on the machine
>> from Access and if that machine did not install Access than it does not
>> know
>> what the object is yet. By using a reference to it in your book, the
>> other
>> machines will know how to use the object.
>>
>> Mike F
>> "Geoff" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hi
>> >
>> > I have installed the Excel calendar on an Excel worksheet where it
>> > works
>> > fine, however when the same worksheet is distributed to other users
>> > this
>> > control either doesn't come up at all, or it comes up but without the
>> > calendar dates being visible.
>> >
>> > The worksheet is not protected, nor does it have any merged cells on
>> > it.
>> >
>> > Can anyone tell me the cause of the problem and how to cure it?
>>
>>
>>

Sorry the link didn't come through, look at this link:

http://www.fontstuff.com/vba/vbatut07.htm

Mike F
"Mike Fogleman" <[email protected]> wrote in message
news:[email protected]...
> NOTE: The Calendar Control is an ActiveX control (actually a file called
> mscal.ocx) supplied with Microsoft Office. It is normally installed with a
> standard installation of Microsoft Office Professional or Microsoft
> Access, but if you can't find it on the list you will need to get hold of
> a copy. If you are distributing your file, or planning to use it on more
> than one computer, you will also need to make sure that the host computer
> has the mscal.ocx file installed. You will find it on the CD that your
> copy of Microsoft Office Professional came on, or you can download a copy
> from here.
>
> [Follow this link for full instructions on downloading and installing the
> mscal.ocx ActiveX Calendar Control file.]
>
>
>
> Mike F
>
> "Geoff" <[email protected]> wrote in message
> news:[email protected]...
>> Thanks for the information Mike, but I have already checked the Microsoft
>> Calendar Control 11.0 under Tools/References in my workbook. The problem
>> is
>> possibly occuring on machines without Access installed. Is there any
>> other
>> way of circumventing this - maybe by the use of code?
>>
>> "Mike Fogleman" wrote:
>>
>>> In your workbook VBA add a reference to the Microsoft Calendar Object
>>> x.0.
>>> Tools\References and put a check next to the reference. Save your book
>>> and
>>> re-distribute. I believe the calendar object is activated on the machine
>>> from Access and if that machine did not install Access than it does not
>>> know
>>> what the object is yet. By using a reference to it in your book, the
>>> other
>>> machines will know how to use the object.
>>>
>>> Mike F
>>> "Geoff" <[email protected]> wrote in message
>>> news:[email protected]...
>>> > Hi
>>> >
>>> > I have installed the Excel calendar on an Excel worksheet where it
>>> > works
>>> > fine, however when the same worksheet is distributed to other users
>>> > this
>>> > control either doesn't come up at all, or it comes up but without the
>>> > calendar dates being visible.
>>> >
>>> > The worksheet is not protected, nor does it have any merged cells on
>>> > it.
>>> >
>>> > Can anyone tell me the cause of the problem and how to cure it?
>>>
>>>
>>>
>
>

Thanks for your help Mike. I'll try this on the problem machines.

"Mike Fogleman" wrote:

> Sorry the link didn't come through, look at this link:
>
> http://www.fontstuff.com/vba/vbatut07.htm
>
> Mike F
> "Mike Fogleman" <[email protected]> wrote in message
> news:[email protected]...
> > NOTE: The Calendar Control is an ActiveX control (actually a file called
> > mscal.ocx) supplied with Microsoft Office. It is normally installed with a
> > standard installation of Microsoft Office Professional or Microsoft
> > Access, but if you can't find it on the list you will need to get hold of
> > a copy. If you are distributing your file, or planning to use it on more
> > than one computer, you will also need to make sure that the host computer
> > has the mscal.ocx file installed. You will find it on the CD that your
> > copy of Microsoft Office Professional came on, or you can download a copy
> > from here.
> >
> > [Follow this link for full instructions on downloading and installing the
> > mscal.ocx ActiveX Calendar Control file.]
> >
> >
> >
> > Mike F
> >
> > "Geoff" <[email protected]> wrote in message
> > news:[email protected]...
> >> Thanks for the information Mike, but I have already checked the Microsoft
> >> Calendar Control 11.0 under Tools/References in my workbook. The problem
> >> is
> >> possibly occuring on machines without Access installed. Is there any
> >> other
> >> way of circumventing this - maybe by the use of code?
> >>
> >> "Mike Fogleman" wrote:
> >>
> >>> In your workbook VBA add a reference to the Microsoft Calendar Object
> >>> x.0.
> >>> Tools\References and put a check next to the reference. Save your book
> >>> and
> >>> re-distribute. I believe the calendar object is activated on the machine
> >>> from Access and if that machine did not install Access than it does not
> >>> know
> >>> what the object is yet. By using a reference to it in your book, the
> >>> other
> >>> machines will know how to use the object.
> >>>
> >>> Mike F
> >>> "Geoff" <[email protected]> wrote in message
> >>> news:[email protected]...
> >>> > Hi
> >>> >
> >>> > I have installed the Excel calendar on an Excel worksheet where it
> >>> > works
> >>> > fine, however when the same worksheet is distributed to other users
> >>> > this
> >>> > control either doesn't come up at all, or it comes up but without the
> >>> > calendar dates being visible.
> >>> >
> >>> > The worksheet is not protected, nor does it have any merged cells on
> >>> > it.
> >>> >
> >>> > Can anyone tell me the cause of the problem and how to cure it?
> >>>
> >>>
> >>>
> >
> >
>
>
>