Drop Down Menu on the Standard Toolbar

[Thyagaraj]

Dear Friends,

Can any one give me a code to create a drop down menu on the standard
toolbar.



Thanks in Advance

Regards
Thyagaraj

 

[Bob Phillips]

Here is an example

With Application.CommandBars("Standard")
With .Controls.Add(Type:=msoControlPopup, temporary:=True)
.Caption = "BobsTest"
With .Controls.Add(Type:=msoControlButton)
.Caption = "SubMacro1"
.OnAction = "submacro1"
End With
With .Controls.Add(Type:=msoControlButton)
.Caption = "SubMacro2"
.OnAction = "submacro2"
End With
'etc.
End With
End With


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)