This is Applicable for Excel 2007 and above versions.
1. To insert the command button or any other controls, add “Insert Controls” in the Quick Access Toolbar as explained in this post.
2. Once the Control is added, click on “Insert Controls” to view what are the available commands that can be inserted in worksheet.
3. Click on Commands Button and draw the control on Excel Sheet.
4. Double click on Command after adding, to insert VBA Macro code for the newly inserted Command.
Insert Command Button in Excel Sheet