View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Martin[_2_] Paul Martin[_2_] is offline
external usenet poster
 
Posts: 133
Default Ribbon's equivalent to CommandBars.ActionControl

With pre-Excel 2007, I could ascertain what user-selection was made
with a custom toolbar menu item using
CommandBars.ActionControl.Index. This menu would be populated from a
worksheet range and knowing the index using this syntax would enable
me to select the cell number from that range.

Now I'm trying to do the equivalent with the Ribbon in Excel 2007. I
can see how to return the control's id property but not the
selection's index. Any suggestions?

Thanks in advance

Paul Martin
Melbourne, Australia