Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
context menu
hi!
can anyone get me started on how to add/remove items from right click menu (via vb.net or vba? ) thanks - eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
context menu
Eric,
An example disabling Insert Comment With Application.CommandBars("Cell") .Controls("Insert Comment").Enabled = False End With and this adds a command With Application.CommandBars("Cell") With .Controls.Add(Type:=msoControlButton, temporary:=True) .BeginGroup = True .Caption = "Insert Date" .OnAction = "myDateMacro" End With End With -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "eric23" wrote in message ... hi! can anyone get me started on how to add/remove items from right click menu (via vb.net or vba? ) thanks - eric |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
context menu
wow
thanks Bob! "Bob Phillips" wrote in message ... Eric, An example disabling Insert Comment With Application.CommandBars("Cell") .Controls("Insert Comment").Enabled = False End With and this adds a command With Application.CommandBars("Cell") With .Controls.Add(Type:=msoControlButton, temporary:=True) .BeginGroup = True .Caption = "Insert Date" .OnAction = "myDateMacro" End With End With -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "eric23" wrote in message ... hi! can anyone get me started on how to add/remove items from right click menu (via vb.net or vba? ) thanks - eric |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
context menu
It's a pleasure.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "eric23" wrote in message ... wow thanks Bob! "Bob Phillips" wrote in message ... Eric, An example disabling Insert Comment With Application.CommandBars("Cell") .Controls("Insert Comment").Enabled = False End With and this adds a command With Application.CommandBars("Cell") With .Controls.Add(Type:=msoControlButton, temporary:=True) .BeginGroup = True .Caption = "Insert Date" .OnAction = "myDateMacro" End With End With -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "eric23" wrote in message ... hi! can anyone get me started on how to add/remove items from right click menu (via vb.net or vba? ) thanks - eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add find and replace to context menu | Excel Discussion (Misc queries) | |||
context menu formatting toolbar | New Users to Excel | |||
Updating context menu in Excel | Excel Discussion (Misc queries) | |||
Add items to context menu | Excel Worksheet Functions | |||
Context sensitive menu | Excel Programming |