Printing code
 

I am trying to set up a printing macro. I currently have connected to a
command button setup to print. When i hit my command button I have an input
box that asks me how many copies to print. However I have no choice to which
printer that I want to select, it goes to my default printer. Any ideas how I
could also add the choice of which printer to select within my input box or
to use something else besides an inout box?

thanks,

Jase

Printing code
 

Add this line of code allowing the user to select their printer...

Application.Dialogs(xlDialogPrinterSetup).Show
--
HTH...

Jim Thomlinson


"Jase" wrote:

I am trying to set up a printing macro. I currently have connected to a
command button setup to print. When i hit my command button I have an input
box that asks me how many copies to print. However I have no choice to which
printer that I want to select, it goes to my default printer. Any ideas how I
could also add the choice of which printer to select within my input box or
to use something else besides an inout box?

thanks,

Jase

Printing code
 

That is exactly what I am looking for, thanks.

Jase

"Jim Thomlinson" wrote:

Add this line of code allowing the user to select their printer...

Application.Dialogs(xlDialogPrinterSetup).Show
--
HTH...

Jim Thomlinson


"Jase" wrote:

I am trying to set up a printing macro. I currently have connected to a
command button setup to print. When i hit my command button I have an input
box that asks me how many copies to print. However I have no choice to which
printer that I want to select, it goes to my default printer. Any ideas how I
could also add the choice of which printer to select within my input box or
to use something else besides an inout box?

thanks,

Jase