Calendar control doesn't work on some machines
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" wrote in message
...
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?
|