Thread: Calendar issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cjtj4700
 
Posts: n/a
Default 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.