User ability to select printer

[jgoulart]

Using the printout command, I don't see a way to allow the user to change his printer. Is there anyway to get the user to specify the printer or to change copies. I can see how to set the ammount of copies but I can't seem to figure out how to give the user an option (when his print command is disabled) to select the printer on a printout other than use a print preview option.

John

 

[Jack in the UK]

Hi --

Click file
click print

see the white section middle top ish, to the right is a arrow/drop down click it. A box apperars that aallows prit selection to any printer is networked or whatever.

Does this help or im misunderstood, sorry

I guess in code try record it and set the network to that default printer, should record ok, but paper selection ie dula bin lazers or manual seems to be effected by the software attached to that printer as does dublex printing.

MY fix is not to print at all, save as unique file name and save in dir made called PRINT and todays date and thend default excel to what printer and papers typr and location and all the rest and then print 1 or all saved docs.



_________________
Good Luck
HTH

Rdgs
==========
Jack in the UK
This message was edited by Jack in the UK on 2002-03-10 14:23

 

[SamS]

try Application.Dialogs(xlDialogPrinterSetup).Show or more appropriately I think you want

Application.Dialogs(xlDialogPrint).Show
This message was edited by SamS on 2002-03-10 16:55