Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2005
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    References (Office 11)

    We are in the process of upgrading from Office 10 to 11 at work in a fully protected environment. We have a mission critical spreadsheet (1 of many but this is the only one with problems) with code, forms, etc.

    For some reason this spreadsheet starts running as soon as it is opened. I tried holding the Shift key down a la Access but this didn't stop the code running. Hitting Ctrl>Break didn't stop it, nor clicking the Reset button etc etc. Therefore, the code will not run correctly as the references are still pointing to Office 10 and we want to reset them to Office 11.

    Has anyone got an idea?

    Thanks

    Robin

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

    Re: References (Office 11)

    If you're not prompted whether to enable macros, macro security is probably set to Low. Set it to Medium (in Tools | Macro | Security...), then open the workbook and click Disable Macros in the Security Warning dialog. You can then edit VBA.

    Note: usually, references are updated automatically when moving to a newer version.

Posting Permissions

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