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


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

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 comple
with newer revisions..

--
lcorey
-----------------------------------------------------------------------
lcoreyl's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=55754

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

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" wrote in message
:

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

Just a quick follow-up he I know this wasn't working at the time, but
we've since added the old commandbars API's back into Office. When you use
them, you get a new ribbon tab (AddIns) where your toolbars show up -
definitely not the optimal thing, since you'll want to integrate with the
ribbon and take advantage of the new functionality there, but at least this
type of code should work.

btw - I just ran the code sample here, and it works fine.

Cheers,
Dan
Excel Team

Note: We've only got a couple weeks to get bugs filed and fixed, so if I've
requested additional info via email, it'd be great if you can get that to us
ASAP. Please include any necessary sample files, as well as detailed repro
steps so that we can try to reproduce the problem on our side. Also - if
you're emailing me directly (definitely the most efficient at this point)
you'll want to fixup my email address to remove everything after danbatt and
before the @.




"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