Printing a sheet in Visual Basic

[B_Taylor]

Hiya Guys,
The program I'm working on will have a button that will allow you to print the sheet from within the visual basic application. I've tried:

Sheets("Scattergraph").PrintOut

But that doesn't open the print dialogue box, which is important, since the running environment for the finished product has multiple printers and so I want the user to be able to choose the one they want to print from.

Any help's appreciated.

[shg]

Perhaps

Application.Dialogs(xlDialogPrint).Show

[B_Taylor]

Ah yes, that works smashingly!

My code now reads:

Sheets("Scattergraph").Select
Application.Dialogs(xlDialogPrint).Show
'Reverts back to sheet1 so user cannot mess around with the output sheets
Sheets("Sheet1").Select