How do I create a custom image for a toolbar?
Instead of
.FaceId = 98
Put...
.Picture = LoadPicture("C:\My picture location")
Note that only certain file types can be used (I don't remember off hand
which ones don't work).
JNW
" wrote:
The toolbar is being generated upon loading of the excel add-in via the
following code:
Set cmdRW = CommandBars.Add(Name:="DT")
With cmdRW
With .Controls.Add(Type:=msoControlButton)
.TooltipText = "New Sheet"
.OnAction = "Sheet"
.FaceId = 98
I know how to design a new button image when creating a toolbar
manually, but how do I do so when creating the toolbar programtically?
Thanks!
|