title: How to Create VBA Add-In with Shared Codes for All Excels?
body: <p>I'm writing VBA codes for multiple Excel spreadsheets, which will be shared with others from time to time. At some point I find there are lots of duplications in my works. So I want to find a way to share codes in a sort of Excel add-in, like the .xla file.</p>
  
  <p>But when I tried to save the Excel file containing shared codes as .xla file, I got some problems:</p>
  
  <ol>
  <li>The file cannot be edit anymore after I save it in the default add-in folder</li>
  <li>If I move the .xls file to a folder other than the add-in folder, and open it directly - I cannot use its classes - which creates problems for sharing the codes</li>
  </ol>
  
  <p>Any ideas to create add-ins in a flexible and powerful way please?</p>
  
  <p>Thanks a lot for the help</p>