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

[emadghazi]

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

[paulked]

Yes, a shared workbook does allow macros but you cannot edit them once it is shared. See here (https://www.oreilly.com/library/view/programming-excel-with/0596007663/ch08s03.html) for more info.

[SamT]

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;

[emadghazi]

Yes, a shared workbook does allow macros but you cannot edit them once it is shared. See here (https://www.oreilly.com/library/view/programming-excel-with/0596007663/ch08s03.html) for more info.

Thank you for the answer

[emadghazi]

Thank you for the answer