Results 1 to 3 of 3

Thread: sharing

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    sharing

    I have a shared workbook with macros/VBA that functions perfectly with all members of the same workgroup. But when accessed from a different workgroup, none of the coding works (also unaccessable from the VBA editor).

    Is this a limitation of Excel? Is something not set right?

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sharing

    At a guess it sounds like a network rights issue. When you say that the coding does not work, what error messages do you get? Are the VBA and worksheets all in the same workbook, or is the VBA in an xla?

    Jon

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sharing

    Could it be the second workgroup have their systems set to disable macros?
    David Grugeon
    Brisbane Australia

Posting Permissions

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