Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Multi user macro (2003)

    I have a macro which is a menu item. This is contained in an Excel document. If a user already has Excel open, other users starting Excel get a message to say the document is in use with the options of Open Read Only or Cancel.
    Is there a way to suppress this message? It's a bit confusing for users. If they don't select Open Read Only then the menu item and macro are not available to them.

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

    Re: Multi user macro (2003)

    > This is contained in an Excel document

    Can you provide more information? Where is this "Excel document" stored, for example?

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

    Re: Multi user macro (2003)

    Added later: Excel workbooks by default can be opened by only one user at a time. There is an option to share a workbook, but I wouldn't recommend using that - it often leads to corruption. So you should give each user an individual copy of the workbook that contains the code.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multi user macro (2003)

    Hi Hans, excel knows to try and load that document because it's in the xlstart directory C:Program FilesMicrosoft OfficeOFFICE11XLSTART and it opens hidden.
    I would have assumed from the message that all the workstations are trying to open the same copy but this doesn't seem to be the case.

    How would you normally create a macro to used by all excel documents and where would it be stored?

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

    Re: Multi user macro (2003)

    It sounds as if clicking the toolbar button tries to open a second instance of Excel. Check Tools | Options..., General tab and make sure that "Ignore other applications" is off (clear).

    The standard location for code that should be available in all workbooks is the Personal.xls workbook in Cocuments and Settings<username>Application DataMicrosoftExcelXLSTART. See Legare Coleman's Personal.xls Tutorial (All).

  6. #6
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multi user macro (2003)

    Thanks Hans - I now have a much better understanding of Excle startup - thank you.
    PS - do you ever sleep?

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

    Re: Multi user macro (2003)

    > do you ever sleep?

    Yes, some 7 hours a night or so <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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