Macro Buttons

W

WVR

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")?
 
G

Gord Dibben

View>Toolbars>Forms

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
 
G

Gord Dibben

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

Many in Autoshapes on the drawing toolbar to start with.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - assign macro to custom toolbar button 1
Excel Macros 3
Macro for individuals worksheets 2
Imbedded button to run macro 3
Which macro module 4
Help with Pivote Table 1
macro help 1
'Cannot insert object' message when I try to put a button on a worksheet 7

Top