+ Reply to Thread
Results 1 to 3 of 3

Calendar issue

  1. #1
    cjtj4700
    Guest

    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. #2
    Ron de Bruin
    Guest

    Re: 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" <[email protected]> wrote in message news:[email protected]...
    > 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. #3
    cjtj4700
    Guest

    Re: 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" <[email protected]> wrote in message news:[email protected]...
    > > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1