Printer Dialog Box
 

Dear All,

What's the code to make the Printer Dialog Box pop up in - I need the users the be able to select various printers on the network and different copy amounts etc.

Does the code vary between XL97 and XP?

Thanks in advance

T

Printer Dialog Box
 

Sub ShowPrinterDialog()
Application.Dialogs(xlDialogPrinterSetup).Show
End Sub

or perhaps you mean the more standard:

Sub ShowPrinterDialog()
Application.Dialogs(xlDialogPrint).Show
End Sub

either should be consistent in all versions since xl5.

--
Regards,
Tom Ogilvy


"Trevor Williams" wrote in
message ...
Dear All,

What's the code to make the Printer Dialog Box pop up in - I need the
users the be able to select various printers on the network and different
copy amounts etc.rha

Does the code vary between XL97 and XP?

Thanks in advance

T

Printer Dialog Box
 

Excellent, thanks Tom

"Tom Ogilvy" wrote:

Sub ShowPrinterDialog()
Application.Dialogs(xlDialogPrinterSetup).Show
End Sub

or perhaps you mean the more standard:

Sub ShowPrinterDialog()
Application.Dialogs(xlDialogPrint).Show
End Sub

either should be consistent in all versions since xl5.

--
Regards,
Tom Ogilvy


"Trevor Williams" wrote in
message ...
Dear All,

What's the code to make the Printer Dialog Box pop up in - I need the
users the be able to select various printers on the network and different
copy amounts etc.rha

Does the code vary between XL97 and XP?

Thanks in advance

T