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.

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

www.OfficeArticles.com


"cldavis" wrote in message
...
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.

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

"cldavis" skrev i melding
...
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.

Hi

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"cldavis" wrote in message ...
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.