info on faceid
If you want to see the caption instead of an icon you have to change the
button's style:
With Btn
.Style = msoButtonCaption
--
Jim
"JohnE" wrote in message
...
| Hello. I'm using Excel 2003 and setting up several buttons. Rather then
a
| picture, the users would prefer text on the button face. Here is a sample
of
| setting the properties but I am not sure of how text is entered for the
| .FaceID. If anyone knows, please let me know.
|
| Set Btn = Tb.Controls.Add(Type:=msoControlButton)
| With Btn
| ' .FaceId =
| .OnAction = "Refresh_Metric"
| .Caption = "This will refresh existing workbook."
| End With
|
| Thanks.
| John
|