how do you create custom buttons in office 2007?

how do you create custom buttons in office 2007?

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

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

<sarcastic font> it's really simple </sarcastic font>
right click in toolbars/select customize
select commands tab
select the button you want to link to a macro
select modify selection/select assign macro

I'm not sure why software companies like to make things more complex with newer revisions...

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" <lcoreyl.2a9z4b_1151771712.5618@excelforum-nospam.com> wrote in
message news:lcoreyl.2a9z4b_1151771712.5618@excelforum-nospam.com...
>
> 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
>

And if you really want to add stuff to the ribbon and not just the QAT,
read the blog on my website.

Patrick Schmid
--------------
http://pschmid.net

"Jon Peltier" <jonxlmvpNO@SPAMpeltiertech.com> wrote in message
news:eM9JLehnGHA.4328@TK2MSFTNGP04.phx.gbl:

> 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" <lcoreyl.2a9z4b_1151771712.5618@excelforum-nospam.com> wrote in
> message news:lcoreyl.2a9z4b_1151771712.5618@excelforum-nospam.com...
> >
> > 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
> >