Macro Buttons
 

I have recorded a macro and I want to create a button and link to the macro.
I don't want to add the button to an existing toolbar. I want the button to
be located in the body of the worksheet.

How do I create the button, move it where I want it on the worksheet, and
edit the name to something that is meaningful to the user (i.e., instead of
"button17")?

Macro Buttons
 

Do you have the rectangle button on your toolbar. It looks like a box.
If so, click on it and drag to wherever desiredright click it and you can
assign a macro and format it.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WVR" wrote in message
...
I have recorded a macro and I want to create a button and link to the
macro.
I don't want to add the button to an existing toolbar. I want the button
to
be located in the body of the worksheet.

How do I create the button, move it where I want it on the worksheet, and
edit the name to something that is meaningful to the user (i.e., instead
of
"button17")?

Macro Buttons
 

ViewToolbarsForms

Select the button drawing tool(second down on right side)

Draw a button, edit the text then right-click and "Assign Macro".


Gord Dibben MS Excel MVP

On Tue, 9 Jun 2009 15:21:02 -0700, WVR
wrote:

I have recorded a macro and I want to create a button and link to the macro.
I don't want to add the button to an existing toolbar. I want the button to
be located in the body of the worksheet.

How do I create the button, move it where I want it on the worksheet, and
edit the name to something that is meaningful to the user (i.e., instead of
"button17")?

Macro Buttons
 

Why a button?
You can assign a macro to any inserted picture.

--
Greetings from New Zealand
"WVR" wrote in message
...
I have recorded a macro and I want to create a button and link to the
macro.
I don't want to add the button to an existing toolbar. I want the button
to
be located in the body of the worksheet.

How do I create the button, move it where I want it on the worksheet, and
edit the name to something that is meaningful to the user (i.e., instead
of
"button17")?

Macro Buttons
 

Or a piece of wordart or any other object you might think of.

Many in Autoshapes on the drawing toolbar to start with.


Gord

On Thu, 11 Jun 2009 09:19:38 +1200, "Bill Kuunders"
wrote:

Why a button?
You can assign a macro to any inserted picture.