View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 39
Default Add Command to Right-Click Menu

I know how to add a macro to the right-click context menu, for example
to add the macro PasteVal:

Sub CreateRightClick()
With Application.CommandBars("Cell").Controls.Add
.Caption = "Paste Values"
.OnAction = "PasteVal"
End With
End Sub


How would I add a conventional command to the right-click menu? Is it
just a question of knowing the exact name of the command? I'm
particularly interested in adding "Conditional Formatting..." to my
right-click menu.

TIA,


Andy