title: Distributing macro as an Add-In to other users
body: <p>I am looking for some tips how to resolve a problem with distributing macro to other users in my company. </p>
  
  <p>I’ve created a specific workbook which holds a bunch of various types of data such as dates, strings and numbers. Each of the users have to manage the same types of data, so we use this workbook as a template. Data is stored in a columns to which I’ve applied a conditional formatting and data validation to prevent users from inserting wrong values. This Workbook contains few Worksheets with specific names. Names of this worksheets appear in the code – to make some specific calculations for each one of them (based on the name of the worksheet).</p>
  
  <p>The problem is that there is a probability that in the future I would like to make some changes to the code for example to make my macro more efficient or to implement some changes that are necessary. </p>
  
  <p>I’ve searched through the internet to find the best solution and I think the best is to create an Add-In to Excel. But I’ve some questions about that.</p>
  
  <ol>
  <li><p>Is this really the best solution? Can someone give me a hint to make it in a better way?</p></li>
  <li><p>If Add-In is the best, is there a way to add this only to specific workbooks (which are my template)?</p></li>
  <li><p>Is it possible to install Add-in when someone opens a specific workbook (using Workbook_Open) and uninstall it when workbooks is closing (using Workbook_BeforeClose). I’ve looked for answers on the web, but this matter is not clear to me. If this is possible, would it affect speed of the closing/opening workbooks?</p></li>
  </ol>
  
  <p>Thanks for any help/advice!</p>