Click to print

G

grayday

I am building a simple little program in excel where end users have t
fill in a couple of fields which get duplicated to a second sheet tha
will be faxed via an Officejet d series. Can someone walk me throug
setting up a button for "Click here to fax" to put on the first dat
entry page that will bring up the print function to print(fax) th
second page, and if possible automatically select which printer to us
(the fax printer is not the default printer).

I know a little about excel but am by no means a veteran, so pleas
keep responses kind of simple.

Thanks in advance for any help you can provide
 
D

Dave Peterson

I'd record a macro when you did it manually. You'll get lots of useable code.

But if the printer is known by different names for each user, you may just want
to pop up the dialog and let the user select the printer.

Application.Dialogs(xlDialogPrinterSetup).Show
or
Application.Dialogs(xlDialogPrint).Show
 
G

grayday

Sounds like a plan.

Thanks a lot for the help here and with the other post, sorry I didn'
see that someone had replied here
 
D

Dave Peterson

Sometimes posting multiple times seems like a good idea--but it usually turns
into more work--for you to find all the responses and for people to type up
responses that you've already gotten.

But glad you have a plan <bg>.
 
Top