Buttons

[Ben T]

Can someone lead me through the creation of a button and how to assign a
macro to it.
Greatly appreciated,
Ben

 

[David McRitchie]

Hi Ben,
If you mean a toolbar button see
http://www.mvps.org/dmcritchie/excel/toolbars.htm

For a shape, you would right click on the shape and assign a macro
http://www.mvps.org/dmcritchie/excel/shapes.htm

For a form, you would right click on the button and assign a macro

 

[Bryan Hessey]

Try
http://www.excelforum.com/showthread.php?t=537386

--

 

[Ben T]

Thanks for responding, I probably did not make myself very clear. The kind
of button I referring to is one that I place on my spread sheet by drawing
its shape and then assign a macro to it. It is a gray rectangle and by left
clicking gives me the option of assigning a macro to it.Thanks David,
Ben

Hi Ben,
If you mean a toolbar button see
http://www.mvps.org/dmcritchie/excel/toolbars.htm

For a shape, you would right click on the shape and assign a macro
http://www.mvps.org/dmcritchie/excel/shapes.htm

For a form, you would right click on the button and assign a macro
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Can someone lead me through the creation of a button and how to assign a
macro to it.
Greatly appreciated,
Ben

 

[Ben T]

Thanks Bryan
After creating the button, How do assign a macro to it?
Thlanks


"Bryan Hessey" <[email protected]>
wrote in message

 

[Bryan Hessey]

Ben,

See David McRitchie's post for which type of button.

--