Printer Dialog Box

[Trevor Williams]

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

 

[Tom Ogilvy]

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

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

 

[Trevor Williams]

Excellent, thanks Tom

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



users the be able to select various printers on the network and different
copy amounts etc.rha