title: Sharing custom macros and custom Excel Ribbon with others via Sharepoint
body: <p>My colleagues and I use Excel 2013 and Sharepoint</p>
  
  <p>I have written some custom macros which I have stored in <code>Personal.xlsb</code>
  I have also customized the ribbon to add a tab to access these macros.</p>
  
  <p>What is the best way of sharing these macros and the ribbon with my colleagues? (and keeping them updated)</p>
  
  <p>One way is as follows (and this needs to be done each time there is a change)</p>
  
  <ol>
  <li>right-click Ribbon | Customize the Ribbon | Import/Export | Export all Customizations and send this XML file to my colleagues and ask them to import it</li>
  <li>Send my colleagues my Personal.xlsb and ask them to overwrite their own with this.</li>
  </ol>
  
  <p>However is there a better way - involving manual effort on the part of my colleagues as little as possible.</p>
  
  <p>I thought perhaps of saving the macros as a sharepoint document, and then editing the XML document to point to this sharepoint document. </p>