View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WhytheQ WhytheQ is offline
external usenet poster
 
Posts: 246
Default Adding AUTOSUM to Cell menu in Excel 2007

In 2003 I could do the following:

Application.CommandBars("Cell").Controls.Add
msoControlSplitButtonPopup, 226

........and an Autosum control would be created in the Cell menu.

(I found 226 by recording a macro of changing a menu)

In 2007 the above line doesn't seem to work. Although it doesn't throw
an error either! ...

Any help greatly appreciated

Regards
JasonQ