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

[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.

 

[Anne Troy]

Try this, cl:
http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_office_applications.htm
*******************
~Anne Troy

www.OfficeArticles.com

 

[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

 

[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