View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SS[_3_] SS[_3_] is offline
external usenet poster
 
Posts: 14
Default Add Icon to Toolbar

I am having troubling finding how to add an icon to my
custom toolbar button.

Set NewSheetCBC = Toolbar.Controls.Add
(Type:=msoControlButton)
With NewSheetCBC
.Caption = "New Sheet"
.State = msoButtonUp
.Style = msoButtonIconAndWrapCaptionBelow
'.Icon = THIS IS WHERE I AM NOT SURE WHAT TO ADD

.TooltipText = "Create a new overtime sheet/new
overtime week."
End With


Can anyone tell me a. is there a set of avilable icons to
pull from, b. where to find it, c. how to write the line
of code?

Thanks

SS