Custom buttons
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 |
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 |
Rick, United Kingdom Wrote: 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 Hi Rick Try dragging the Smiley onto a toolbar, then right click on it and select Edit button image, a large version of the smiley will appear in a dialogue box, you can change the individual squares in the large image to form any pattern/picture you require -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=398773 |
All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com