Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2008
    Location
    Medway, Kent, United Kingdom
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Morning Loungers

    Iíve not been around for a while, great new look to the forum.

    The attached file is a copy of part of the spreadsheet we use to log our method statements. In order to speed up the data entry process a user form opens when a cell containing a date is selected, then the user clicks on a date on the form to populate the cell.

    The spreadsheet is saved on a shared drive on the company network and it works fine on my machine and some others but the user form refuses to appear when the spreadsheet is opened on some other machines.

    Can anyone tell me where I need to look to fix the problem please?

    Regards

    Graeme
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No all systems have the calendar control installed, it is not by default available on all variations of Office.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Sep 2008
    Location
    Medway, Kent, United Kingdom
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the reply.

    Yes, the macro only works on the machines that have MS Access installed on them. I will need to get our IT administrators to register mscal.ocx.

    Thanks

    Regards

    Graeme

Posting Permissions

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