title: Excel isn't saving VBA reference
body: <p>I created an Excel .xlsm file with a bunch of functionality in some VBA Modules/Classes and now I've decided to separate out the code because it will be shared across 4 different sites.</p>
  
  <p>I saved the vba_code.xlsm to a shared location and created my 4 different siteXYZ.xlsm files.</p>
  
  <p>In each siteXYZ.xlsm file I would go to the "Tools | References" menu in the VBA editor and add a reference to the shared vba_code.xlsm at a shared file location \share_location\fileLocation\vba_code.xlsm</p>
  
  <p>At this point, I tested out the functions in siteXYZ.xlsm and everything would work fine.</p>
  
  <p>However, every time I saved siteXYZ.xlsm, closed Excel and then reopened the file it would lose the reference to my vba_code.xlsm file.</p>
  
  <p>How can I keep the VBA references saved with my siteXYZ.xlsm file?</p>