title: Excel VBA sharing addins between different read-only instances of same workbook
body: <p>My team and I share this workbook on a network drive. This workbook utilizes a few custom add-ins necessary for some custom functionality. These add-ins get automatically installed by custom VBA code I have added without any action on the part of the user. It seems that only I can use the add-ins - other team members have problems trying to load the add-ins, they get this error:</p>
  
  <pre><code>Run-time error 1004 Unable to copy add-in to library.
  </code></pre>
  
  <p>The error occurs when trying to run</p>
  
  <pre><code>Application.AddIns.add(&lt;addin_name&gt;)
  </code></pre>
  
  <p>The add-ins are located only on the Windows network share. I've written the code to ignore the prompt for copying the add-in to addins folder on local drive, because I don't want this to happen. This is a very annoying problem because I cannot debug it fully myself, I need the cooperation of my team members which is limited. Help greatly appreciated, thanks.</p>