title: Locating Command Buttons in Excel VBA
body: <p>I am maintaining a large spread sheet at work and there are ActiveX command buttons throughout the code. One sheet I am currently working on has almost 100 of these. I have made sure the button itself is visible as some of the buttons are hidden/unhidden depending on the flow of the code.</p>
  
  <p>Is there a way I can find whereabouts on the sheet itself the button is located that the VBA code is pointing to? Here is a snippet:</p>
  
  <pre><code>enter code here
  Private Sub CommandButton4_Click()
  Application.Goto Range("Add_Trainees"), True
  CommandButton3.Visible = True ' unhides menu button
  CommandButton81.Visible = True ' hides SC1
  CommandButton97.Visible = True ' hides SC2
  End Sub
  </code></pre>
  
  <p>I am trying to find where on the sheet where command buttons 3, 81 and 97 are located. </p>
  
  <p>TIA for any help/suggestions.</p>