He said Excel 2007. Your technique works in Excel 97 through 2003, but has
been deprecated. It's a shame too, because that approach allowed a great
deal of flexibility.

The way to do it is to right click on the control you want, and select the
Add to Quick Access Toolbar, or click the down arrow on the end of the QAT
and select Customize Quick Access Toolbar. You can only add things to the
QAT, and this can only be located above or just below the Ribbon, not close
to where the user wants to use it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"lcoreyl" wrote in
message ...

embedded in sheets, just use the control toolbox to click wherever you
want it. To make a toolbar, or add a button to an existing toolbar use
something like:

Set NewToolbar = Application.CommandBars.Add(Name:="newToolbar",
temporary:=False)
NewToolbar.Visible = True
Set NewButton = NewToolbar.Controls.Add(Type:=msoControlButton,
ID:=2950)
With NewButton
FaceId = 583
OnAction = "Macro name here"
Caption = "Macro description here"
End With


--
lcoreyl
------------------------------------------------------------------------
lcoreyl's Profile:
http://www.excelforum.com/member.php...fo&userid=2042
View this thread: http://www.excelforum.com/showthread...hreadid=557540