Allow us to customise the "right-click menu option"
We are already able to customise the ribbon menus. It would be great if we could also customise the right-click menu options. In particular the following would be useful:
- Conditional formatting
However, add these may make it too cluttered for some users, so it would be great if you could choose what items are shown.
This is an extension of this idea by Emma...
I apologize in advance for not being able to credit whoever originally wrote this, it's just something I copied into my personal.xlsb. Not used recently, but it worked the last time I needed it.
' Macro that adds an extra command to the context menu of a cell
' The command will be removed when you quit Excel.
Dim cbr As CommandBar
Dim cbb As CommandBarButton
Set cbr = CommandBars("Cell")
Set cbb = cbr.Controls.Add(Type:=msoControlButton, Temporary:=True)
.Caption = "Don't Click This Option"
.Style = msoButtonCaption
.OnAction = "KilroyWasHere"
' Macro that will be called from the custom command
MsgBox "I warned you...", , ""
Carl Kirstein commented
Also include the VBA controls to manage this.
Also, the option to format all aspects of the cell as we could in the 2010 version, rather than just being able to format the number style.