custom right click menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is is possible to customize the right click menu in Excel or any other office
application?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom right-click menu without changing Excel.App 1
Customizing right click menu 1
Cell context menu in XL2007 5
add "paste values" to right click menu 6
How to open workbooks in different Excel? 2
Displaying A custom menu as a popup menu 5
user interface only question 4
right click menu 1

Back
Top