title: Updating a macro to be identical across all worksheets (or making the code more global?)
body: <p>I have a workbook with a few dozen worksheets, which is growing. I might also end up with copies of this workbook pretty soon.</p>
  
  <p>Each sheet is based on the same worksheet template, which includes a macro on its <code>Worksheet_Change</code> event for auto-calculations. As I improve the workbook and add capabilities, and sheets are added, it's taking longer and longer to copy-paste the updated macro to all sheets.</p>
  
  <p>I'm wondering if there's a way to either:</p>
  
  <ol>
  <li>Make another macro that copies the updated version of the macro from the template to all other worksheets, overwriting the old versions in the process</li>
  </ol>
  
  <p>And/or</p>
  
  <ol start="2">
  <li>Move the code from worksheet_change to a more global place where I'd only need to update one version of it per workbook (which is fine and much better than updating 20+ worksheets manually across soon-to-be 3 workbooks...)</li>
  </ol>
  
  <p>Solution #2 would be better because more elegant I think? But I have no clue if it's possible. Barring that I'd gladly take #1 for the time-saving aspect!</p>
  
  <p>Thank you in advance.</p>