Consulting

Results 1 to 5 of 5

Thread: How to share an Excel file containing a macro on the network

  1. #1

    How to share an Excel file containing a macro on the network

    welcome everybody
    Is there a possibility to share an Excel file that contains a macro on the network so that it works on multiple users at the same time
    Thank you

  2. #2
    VBAX Expert paulked's Avatar
    Joined
    Apr 2006
    Posts
    509
    Location
    Yes, a shared workbook does allow macros but you cannot edit them once it is shared. See here for more info.
    Semper in excretia sumus; solum profundum variat.

  3. #3
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,990
    Location
    Every network is unique; talk to your network administrator about the best method to accomplish what you desire.

    If they are entering and saving Data, a Shared Excel file is not a good method.

    For example, when I designed an Estimator for the sales team of a construction company, a Shared file worked well because all the Data for each Estimate and Sale was stored in a New Workbook... No data was stored in the Shared file;
    I always expect the student to do their homework and find all the errrors I leeve in.

    Please take the time to read the Forum FAQ

  4. #4
    Quote Originally Posted by paulked View Post
    Yes, a shared workbook does allow macros but you cannot edit them once it is shared. See here for more info.
    Thank you for the answer

  5. #5
    Thank you for the answer

Posting Permissions

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