View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
galimi[_2_] galimi[_2_] is offline
external usenet poster
 
Posts: 65
Default 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?