title: Is there a way to see if a VBA function is used in Excel?
body: <p>I am an intern working on cleaning up a horrible, horrible mess of a calculator made with Excel and VBA.  I've never really played with VBA in the past, so this is all very new to me, so please forgive me if I am asking the wrong questions, I am here to learn!</p>
  
  <p>The first thing I am trying to do is understand the order of operations in this whole mish-mash.  There are 12 excel sheets holding variables and tables for the calculator, and looking through them it <i>looks</i> like not all of the functions defined in the VBA side actually get called.  Unfortunately there are far to many cells for me to look through individually, so I was wondering if there was a way to do it from the VBA side in the editor (Microsoft Visual Basic for Applications) that comes with excel when you turn on the developer tools.</p>
  
  <p>I have tried commenting out entire functions, then updateing the code to observe if it breaks, but besides comparing the new output to an un-altered version of the sheet cell by cell, well... it's not really feasable if I want to finish it this month =(.  </p>
  
  <p>Any help would be greatly appreciated!</p>
  
  <p>-James</p>
  
  <p>TL;DR:  Is there an easy way to check if a function is actually used in VBA?</p>