ExcelBanter - custom right click menu

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - custom right click menu (https://www.excelbanter.com/excel-programming/321762-custom-right-click-menu.html)

Father of 7

custom right click menu

Is is possible to customize the right click menu in Excel or any other office
application?

galimi[_2_]

custom right click menu

Yes, here is some example code

Sub addmenu()
Set nbar = Application.CommandBars("Cell")
Set ntrnew = nbar.Controls.Add

ntrnew.Caption = "Right Click"
ntrnew.Visible = True
ntrnew.BeginGroup = True
ntrnew.FaceId = 110
ntrnew.OnAction = "Proceduretobeexecuted"

Set nbar = Nothing
Set ntrnew = Nothing
End Sub

http://HelpExcel.com

"Father of 7" wrote:

Is is possible to customize the right click menu in Excel or any other office
application?

All times are GMT +1. The time now is 12:25 PM.