Another little ? on CommandBars("Cell")
 

hi
Is there any way one can have a right click menu that scrolls right to another option (similar to the "Format - Columns - Width" on the menubar) rather than the "..." leading to a dialog box? If so could you insert what code I need into
With .Controls.Add(msoControlButton
.Caption = "DOWN on tick
.OnAction = "Amend_BidAsk_Tick_DOWN
End Wit
ie. the user right clicks, scrolls to 'DOWN on tick' which then scrolls right to give 2-3 new options..
Again, huge thanks in advance. Rgds. Brownie

Another little ? on CommandBars("Cell")
 

Provided sample code in response to your previous post.

--
Regards,
Tom Ogilvy

"Brownie" wrote in message
...
hi,
Is there any way one can have a right click menu that scrolls right to
another option (similar to the "Format - Columns - Width" on the menubar)
rather than the "..." leading to a dialog box? If so could you insert what
code I need into:
With .Controls.Add(msoControlButton)
.Caption = "DOWN on tick"
.OnAction = "Amend_BidAsk_Tick_DOWN"
End With
ie. the user right clicks, scrolls to 'DOWN on tick' which then scrolls
right to give 2-3 new options...
Again, huge thanks in advance. Rgds. Brownie.