Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
looking for ideas for calendar in sheet with separate months | Excel Worksheet Functions | |||
Erasing Outlook Calendar from within Excel | Excel Discussion (Misc queries) | |||
Calendar and info for that date | Excel Discussion (Misc queries) | |||
Weekly data into Calendar Weeks | Excel Worksheet Functions |