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
|