View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brownie Brownie is offline
external usenet poster
 
Posts: 6
Default 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