Thread: info on faceid
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
johne johne is offline
external usenet poster
 
Posts: 40
Default info on faceid

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