You can use any object you want and assign a macro to it.

A picture, a piece of Wordart, a button from the Forms Toolbar, a drawing from
the Drawing toolbar, a photo of your mother.................


Gord Dibben MS Excel MVP

On Sat, 21 Jul 2007 15:46:00 -0700, Fritz
wrote:

I don't think this is what I want. I want to design/draw my own "box" on a
woorksheet. Then I want to assign a macro to it to print the "print area" of
the work sheet.

"Kevin" wrote:

Fritz,
Right click on any blank area of the "Menu bar" and choose "Customize..."
In the resulting "Customize" dialog box with the "Commands" tab selected
under "Categories:" choose "Macros"
In the right hand pane, drag the smiley face button to where ever you want
it on your menu bar or in your menus.
DO NOT close the "Customize" dialog box.
Right click the new smiley button, at the bottom of the list is "Assign
Macro..."
The "Assign Macro" dialog box opens with your list of macros to choose form.
Hope this helps.
-Kevin

"Fritz" wrote in message
...
I know how to design a button, and I know how to record a macro but I can't
figure out how to attach the macro to the button?