How do I add a button to run a macaro in Excel XP?

C

cldavis

I'm trying to create a button, using a macro, to print 3 of 5 pages in a
workbook. I can create the macro just fine, however, I want my users to bve
able to use hit a "button" either on the toolbar or in the first sheet, and
have it print those sheets automatically.
 
H

Harald Staff

Hi

Pick an object from the Drawing toolbar (View > Toolbars menu if not there)
and put it onto your sheet. Rightclick the thing, choose "assign macro" and
assign your macro.

(There are other ways, but this solution will always look good :)

HTH. Best wishes Harald
 
R

Ron de Bruin

Hi

Right click on a toolbar and click on Forms
Draw a button on your sheet and assign your macro to it
 
Top