Command Buttons in Cell

**oht** · 10-04-2006, 11:07 AM

How do you create a command buttom in a cell that when press will acivate a mcaro that related to the the VBA sub CommandButton() ? I saw one in a spreadsheet but do not know how the buttons is created.

Thanks

oht

**starryknight64** · 10-04-2006, 02:57 PM

Right click on any toolbar.
Goto Customize
Click on the Commands tab
Under Categories, select Forms
Under Commands, click and drag the button icon to any spot on your toolbar(s).
Click Close
Click on the newly added button icon.
Click and drag the size of your new button onto the spreadsheet.
After that you should be able to choose which macro to execute whenever you press that button.

I hope this helps!