Thread: Macro to button
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fritz Fritz is offline
external usenet poster
 
Posts: 29
Default Macro to button

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?