VBA - icon on a personal right-click menue

S

Siberianhusky

dear ng,
how can i put on an icon on a personal right-click menue. i use this code:

With .Controls.Add(msoControlButton, , 1, 4, True)
.BeginGroup = True
.Tag = "Add_Subhead"
.Caption = "Add Subhead"
.OnAction = "TabellenKopfEinfuegen"
End With

and it works great. i just would like to have an icon too.

thanks and regards,
Siberianhusky
 
S

Shyam Pillai

If you are creating a COM add-in, you can load your own icon. But if it's a
VBA solution you are restricted to the icons provided by Office itself
(http://skp.mvps.org/faceid.htm ) or workarounds likes copying the image to
the clipboard and then using PasteFace method to put it on the menu item.
 
S

Siberianhusky

thanks to all. i see, there is not really a way.
@Shyam Pillai: graet link!

regards,
Siberianhusky
 
Top