title: Creating custom Excel Ribbon Tab, which works in any workbook
body: <p>I have surfing the net for months already and haven't really found a solution to the following task I would like to perform. Here is a deal.</p>
  
  <p>I am writing a bunch of code in VBA, which basically creates a new worksheet in a workbook with a specific type of calculators (there are many) for job purposes. One sheet - one type of calculator/analysis.</p>
  
  <p>What I want to accomplish is, that due to increasing amount of code - I would like to put everything on to the ribbon, so I can access a macro through that. However, the job is based on to the case-to-case analysis basis, so the each new project requires a new Excel workbook to be created, where I can choose the calculator I want and do the job.</p>
  
  <p>In addition to that, it requires to be launched on all computers with Excel in the network, with ability for me to be able to modify/add a code to the macro, so that all PC's can stay up-to-date simultaneously.</p>
  
  <p>To wrap-up shortly:</p>
  
  <ul>
  <li>There is a bunch of VBA macros (which I'm constantly updating/adding);</li>
  <li>I need to access those macros through the Ribbon in any new workbook (not the one macro are located) on a number of computers in the network;</li>
  <li>There is a need to provide instant updates of the code for Ribbon and macro users.</li>
  </ul>
  
  <p>SO, is there any solution, like - I create 2 files (one with Ribbon configuration, another with calculators) and drop them into the server folder? Each user access them once during the installation (basically locating the folder, where the addins are located), and if I need to modify something - I do it with those two files in the server folder and that's it.</p>
  
  <p>If it's not real or pretty hard (for non-programmer) to instantly update all the users, the manual update can work out, but the minimum of being able to access the ribbon in each new workbook is a must.</p>
  
  <p>Thank you in advance for help.</p>