excel help !! how to create a command button ?

[maarksparky]

Hi folks,

I have made a spreadsheet and want to add a button at the bottom which emails the spreadsheet by clicking

I have gone in Visual Basic Toolbar thing and selected command button(activex control) which allows me to draw a button but Im stuck after that...

please advise..

 

[maarksparky]

just found that a macro needs to be assigned.. but I dont know how ?? lol

can anyone help..

 

[techquest]

Do you not want to use the Email Button that is included in the Standard Toolbar for excel 2003 and onwards?