Macro Buttons

  • Thread starter Thread starter WVR
  • Start date Start date
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")?
 
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
 
Or a piece of wordart or any other object you might think of.

Many in Autoshapes on the drawing toolbar to start with.


Gord
 
Back
Top