View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Drop Down Menu on the Standard Toolbar

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)

"Thyagaraj" wrote in message
oups.com...
Dear Friends,

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



Thanks in Advance

Regards
Thyagaraj