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