Can someone lead me through the creation of a button and how to assign a
macro to it.
Greatly appreciated,
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

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

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

--

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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537650

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





"David McRitchie" wrote in message
...
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

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

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


"Bryan Hessey"
wrote in message
news:Bryan.Hessey.273usa_1146447300.7751@excelforu m-nospam.com...

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

--

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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537650

Ben,

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

--

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


"Bryan Hessey"

wrote in message
news:Bryan.Hessey.273usa_1146447300.7751@excelforu m-nospam.com...

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

--

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


--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=537650



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537650