i should have noted that i am a beginner ... there used to be a way in
office 10 to right click on a tool-bar button and assign a macro - real easy
to do. do you know if this is still available?

"lcoreyl" wrote:

>
> 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
>
>