title: How do I dynamically create a button on my Active Sheet?
body: <p>So I have created a main menu of sorts in my workbook where if the user clicks a button, a new sheet is created and opened for the user to see some data.</p>
  
  <p>Now, I want to dynamically <em>(through VBA code)</em> create a button on the currently active sheet with data that gives the user to close the sheet (<em>essentially deleting the ActiveSheet and returning to the Main Menu</em>)</p>
  
  <p>I tried looking at VBA help for info on the button control but all I can find is info on CommandButton (which I believe is only to be used in a UserForm).</p>
  
  <ul>
  <li>Am I wrong in this belief and can CommandButton be used outside of Userforms as well?</li>
  <li>Or is there a Button object that I am unable to find?</li>
  </ul>
  
  <p>I searched on this topic and only found this post, but it doesn't work. I am using Excel 2010 if that helps.
  <a href="https://stackoverflow.com/questions/4559094/how-to-add-a-button-programmatically-in-vba-next-to-some-sheet-cell-data">How to add a button programmatically in VBA next to some sheet cell data?</a></p>