ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Drop Down Menu on the Standard Toolbar (https://www.excelbanter.com/excel-programming/367368-drop-down-menu-standard-toolbar.html)

Thyagaraj

Drop Down Menu on the Standard Toolbar
 
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

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





All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com