software

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
www.mvps.org/dmcritchie/excel/toolbars.htm

For a shape, you would right click on the shape and assign a macro
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

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

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

--

Ben T Wrote:
gt; Can someone lead me through the creation of a button and how to assign
gt; a
gt; macro to it.
gt; Greatly appreciated,
gt; Ben--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=537650Thanks 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,
Benquot;David McRitchiequot; gt; wrote in message
...
gt; Hi Ben,
gt; If you mean a toolbar button see
gt; www.mvps.org/dmcritchie/excel/toolbars.htm
gt;
gt; For a shape, you would right click on the shape and assign a macro
gt; www.mvps.org/dmcritchie/excel/shapes.htm
gt;
gt; For a form, you would right click on the button and assign a macro
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Ben Tquot; gt; wrote in message
gt; ...
gt;gt; Can someone lead me through the creation of a button and how to assign a
gt;gt; macro to it.
gt;gt; Greatly appreciated,
gt;gt; Ben
gt;gt;
gt;gt;
gt;
gt;
Thanks Bryan
After creating the button, How do assign a macro to it?
Thlanksquot;Bryan Hesseyquot; gt;
wrote in message
news:Bryan.Hessey.273usa_1146447300.7751@excelforu m-nospam.com...
gt;
gt; Try
gt; www.excelforum.com/showthread.php?t=537386
gt;
gt; --
gt;
gt; Ben T Wrote:
gt;gt; Can someone lead me through the creation of a button and how to assign
gt;gt; a
gt;gt; macro to it.
gt;gt; Greatly appreciated,
gt;gt; Ben
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=537650
gt;

Ben,

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

--

Ben T Wrote:
gt; Thanks Bryan
gt; After creating the button, How do assign a macro to it?
gt; Thlanks
gt;
gt;
gt; quot;Bryan Hesseyquot;
gt; gt;
gt; wrote in message
gt; news:Bryan.Hessey.273usa_1146447300.7751@excelforu m-nospam.com...
gt; gt;
gt; gt; Try
gt; gt; www.excelforum.com/showthread.php?t=537386
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Ben T Wrote:
gt; gt;gt; Can someone lead me through the creation of a button and how to
gt; assign
gt; gt;gt; a
gt; gt;gt; macro to it.
gt; gt;gt; Greatly appreciated,
gt; gt;gt; Ben
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=537650
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=537650