Execute Autosum from within VBA

[BLBlack]

I would like to execute Autosum from within VBA.
I have a "custom" tool bar with one button (autosum) on it.

The following code fragment that worked in Excel 2000 no longer work's in Excel 2003.

Dim cb as CommandBarButton
Set cb = CommandBars("Custom").Controls(1)
cb.Execute

The code does not crash, it simply does nothing.
For excel 2003, I believe Autosum is now an msoControlSplitButtonPopup; but I don't know how to make it work.

 

[chilly442]

Have you tried to record a Macro? Even if its not right, it might point you in the right direction.

Chilly442