title: How to store macros in one file shared among several users? (not PERSONAL.xls)
body: <p>I have a 20 excel files with Automation written in VBA where the workflow is similar but there is some customizations in each of the files. I would like to have 20 files, each file per task, but I would like to put all macros into one file, with all the customizations. This will simplify fixing/changing the automation.</p>
  
  <p>I want to have basically one file GlobalMacros.xls somewhere in a shared drive which contains all the modules that do not contain customizations, and only have references to it in the proper files.</p>
  
  <p>Personal.xls is not an answer as I do not want users/team members to feel the changes at all.</p>
  
  <p>Please tell me if there is a solution and what are downsides.</p>
  
  <p>Solution 1:
  My solution is to make the module in GlobalMacro.xls and then add just a reference to the module in each file. The downside is it could slow down the execution of the macros because the GlobalMacros.xls will be opened and closed in the background each time any module is called out. Also is it possible for several users using these macros at the same time?</p>
  
  <p>Has anyone got any better solutions? Maybe someone had a similar problem in the past.</p>