Check out this article, Rick. Should help you a ton.
http://www.officearticles.com/misc/m...ica tions.htm
************
Anne Troy
www.OfficeArticles.com

"Rick, United Kingdom" wrote
in message ...
hi, can i assign a commandbutton sub() to a custom button to sit in the
toolbar? and how do i assign a vb macro to this custom button? and is
there a
way to change the look to the custom button to something apart from the
smiley face? thanks