Command Buttons in Cell

[oht]

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]

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

I hope this helps!

[oht]

It sure worked. Saving me pulling all my hair off. Thank you very much.

Regards

oht

[starryknight64]

Not a problem! After all, we don't want bald excel users!