SOMEONE MUST KNOW!!... keepItCool?? Tom?? Dave??

W

WhytheQ

I previously posted:

Somebody must know:
In Excel 2000 I was able to use the following code to add the Autosum
control to a custom toolbar:

Add(msoControlButton, 226)


In Excel 2003 this doesn't seem to work anymore - anyone know what
number it is now?
Any help greatly appreciated,
Jason.


I've since found control button ID 2018 which says 'Sum' but doesn't
seem to autosum?
I could use a random faceID and add a routine of my own but it'd be a
lot easier if I could expose Excel's built in function.

Help appreciated,
Jason
 
D

Dave Peterson

I recorded a macro when I added autosum to a test toolbar:

Application.CommandBars("Custom 1").Controls.Add _
Type:=msoControlSplitButtonPopup, ID:=226, Before:=2

Notice the difference in type.

Now back to excel and notice that the autosum button in xl2003 (maybe
xl2002????) has been enhanced to include a dropdown arrow that gives more
functionality.
 
W

WhytheQ

Dave: you've dug me out of a hole once again!!
Obviously I didn't realise that this could be recorded: but I do now,
which is excellent.

Thanks again,
Jason.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top