title: Customizing a ribbon with VBA in Excel
body: <p>I've already learned that creating a custom tab is in Excel not possible in <a href="https://stackoverflow.com/questions/8850836/how-to-add-a-custom-ribbon-tab-using-vba" title="8850836/how-to-add-a-custom-ribbon-tab-using-vba">this</a>! post (unlike i.e. MSProject)</p>
  
  <p>Specifically, can I change the paths of the macros to the current location ?</p>
  
  <p>Edit
  It seems that this <a href="http://www.rondebruin.nl/win/s2/win013.htm" rel="nofollow noreferrer">page</a> may lead to the answer, but I still don't know how, though</p>
  
  <p>Some more in-detail description of the situation:</p>
  
  <p>The user will download a file, which contains a list of materials, equipment, labor. Each column contains information about quantities, pricing etc
  When the user click on this button I want to create (I have created manually), a macro called 'Main' in another workbook launches and copies the whole sheet (the contents) to itself and performs some things that procedures do, on it.</p>
  
  <p>So the problem I'm facing, is twhen I'm sending a new version to the client, he has to put it in the exact location or it won't work. Since there's a mix of Mac and Windows computers involved, I'd rather see a situation where the button is assigned to the procedure when the user opens WorkBook B (the one that contains the code).</p>
  
  <p>This way, a new version has to be openened only once, and then for continuous use, the user can just open the downloaded file, click the appropriate button and WorkBook B will open itself and execute.</p>
  
  <p>Maybe there's other ways to go about this. I haven't checked if it's not easier to assign a button to the quick access toolbar...</p>