• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

excel help !! how to create a command button ?

maarksparky

DW Member ++
Joined
Dec 11, 2006
Messages
2,099
Likes
15
#1
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

DW Member ++
Joined
Dec 11, 2006
Messages
2,099
Likes
15
#2
just found that a macro needs to be assigned.. but I dont know how ?? lol

can anyone help..
 

techquest

Inactive User
Joined
Oct 29, 2007
Messages
1,679
Likes
42
#3
Do you not want to use the Email Button that is included in the Standard Toolbar for excel 2003 and onwards?