Calendar issue
 

Hi,
I have incorporated a nice pop up calendar into a sheet on a .xlt
workbook. I created the workbook using XL 2003 Pro. It works like a charm via
the shortcut on my desktop. However, the calendar will not work for any other
member of my company. (none of which have XL 2003 Pro). Is that the reason?
It is control calendar 8.0.
A couple different events are occuring:

1) they open, enable macros, click in range for calendar and get an error
message and highlights VBA line "Calendar1.Value = Date" or

2) The calendar pops up as it should but it is a blank white square. Looks
just like I have formatted it but with no dates, text etc. They can even
depress any of the date squares but nothing happens??

Again, works like a dream on the shorcut I have, which is exactly what I
distributed out to all employees last night. 20 + replies explaining that the
calendar doesn't work.

Calendar issue
 

Hi cjtj4700

Create you workbook in a oldest Excel version and be sure that they
also have Access installed.

This control is a part of Access
You can also download it here
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"cjtj4700" wrote in message ...
Hi,
I have incorporated a nice pop up calendar into a sheet on a .xlt
workbook. I created the workbook using XL 2003 Pro. It works like a charm via
the shortcut on my desktop. However, the calendar will not work for any other
member of my company. (none of which have XL 2003 Pro). Is that the reason?
It is control calendar 8.0.
A couple different events are occuring:

1) they open, enable macros, click in range for calendar and get an error
message and highlights VBA line "Calendar1.Value = Date" or

2) The calendar pops up as it should but it is a blank white square. Looks
just like I have formatted it but with no dates, text etc. They can even
depress any of the date squares but nothing happens??

Again, works like a dream on the shorcut I have, which is exactly what I
distributed out to all employees last night. 20 + replies explaining that the
calendar doesn't work.

Calendar issue
 

That's what I was hoping you would not say! Or get my IT dept. to install my
version of XL.

Thanks as always Ron.


"Ron de Bruin" wrote:

Hi cjtj4700

Create you workbook in a oldest Excel version and be sure that they
also have Access installed.

This control is a part of Access
You can also download it here
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"cjtj4700" wrote in message ...
Hi,
I have incorporated a nice pop up calendar into a sheet on a .xlt
workbook. I created the workbook using XL 2003 Pro. It works like a charm via
the shortcut on my desktop. However, the calendar will not work for any other
member of my company. (none of which have XL 2003 Pro). Is that the reason?
It is control calendar 8.0.
A couple different events are occuring:

1) they open, enable macros, click in range for calendar and get an error
message and highlights VBA line "Calendar1.Value = Date" or

2) The calendar pops up as it should but it is a blank white square. Looks
just like I have formatted it but with no dates, text etc. They can even
depress any of the date squares but nothing happens??

Again, works like a dream on the shorcut I have, which is exactly what I
distributed out to all employees last night. 20 + replies explaining that the
calendar doesn't work.