View Full Version : How to share an Excel file containing a macro on the network
emadghazi
10-12-2019, 04:46 PM
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
10-12-2019, 05:42 PM
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.
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
10-13-2019, 11:30 AM
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
10-13-2019, 11:30 AM
Thank you for the answer
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.