Excel Print Macro

Pantorales · 05-23-2009, 09:06 AM

I have a workbook with two worksheets. One has an input menu (Menu) and the second one has the computations (Report).

How can I create a Macro to print the Report sheet from the Menu sheet?. I'm new at using macros

teshiburu1988 · 05-23-2009, 09:39 AM

you would need to create a button, right clicking on the menu bars and selecting control toolbar and then selecting the "button" icon and drawing your button following that, right click on the button and select view code... using the following code will enable you to print to the default printer

Code:

Worksheets("Report").PrintOut

or you can be more specific if you have to print to a specified machine (i often use this option to print to "PrimoPDF" or another PDF creator)

Code:

Worksheets("Report").PrintOut ActivePrinter:="INSERT PRINTER NAME HERE"

with the above codes you need to leave all quotation marks in (") if you have any issues please don't hesitate to upload your sheet and i can put the button examples on for you including the code...

Teshi

05-23-2009, 09:06 AM	#1 (permalink)
Pantorales Registered User Join Date: May 2009 Posts: 2 OS: XP Pro	Excel Print Macro I have a workbook with two worksheets. One has an input menu (Menu) and the second one has the computations (Report). How can I create a Macro to print the Report sheet from the Menu sheet?. I'm new at using macros

05-23-2009, 09:39 AM	#2 (permalink)
teshiburu1988 Registered User Join Date: May 2009 Posts: 11 OS: XP SP3	Re: Excel Print Macro you would need to create a button, right clicking on the menu bars and selecting control toolbar and then selecting the "button" icon and drawing your button following that, right click on the button and select view code... using the following code will enable you to print to the default printer Code: Worksheets("Report").PrintOut or you can be more specific if you have to print to a specified machine (i often use this option to print to "PrimoPDF" or another PDF creator) Code: Worksheets("Report").PrintOut ActivePrinter:="INSERT PRINTER NAME HERE" with the above codes you need to leave all quotation marks in (") if you have any issues please don't hesitate to upload your sheet and i can put the button examples on for you including the code... Teshi