Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Compile error in hidden module ? (Excel 2002)

    Hi

    I have a workbook which contains a form name frmAncils, when used on my workstation, everything is OK

    When I load it on one laptop it works fine.

    When I load it on another laptop I get this error Compile error in hidden module frmAncils.

    Help Please

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compile error in hidden module ? (Excel 2002)

    Since the problem occurs only on a specific PC, it could be a problem with VBA references. If you can open the workbook at all on the laptop (try holding the Shift key down while opening it if you can't open it normally), activate the Visual Basic Editor and select Tools | References... Are there any references starting with MISSING? If so, which one(s)?
    Note: it is only useful to try this on the problem machine, not on your own workstation, since the problem doesn't occur there.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Compile error in hidden module ? (Excel 2002)

    Hi Hans

    Once again I am in your debt . There was a MISSING Calendar control, once removed the form loaded.

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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