Amending Right-Click Options
Hello everyone
I've added options to the right-click menu using
With Application.CommandBars("Query").Controls.Add
(temporary:=True)
.Caption = "Download All &Transactions for this
Element"
.BeginGroup = True
.FaceId = 458
.OnAction = "DownloadAllTransactionsForThisElement"
End With
Now I'd like to remove all the default options that
appear when I right-click on a cell that is part of
a "Query", particularly the "Edit Query" and "Data Range
Properties Options". Does anyone have any ideas?
Thanks in advance
Matt
|