Printing from a Macro!

[cosfreelance]

Hi All,

I have written a macro to perform functions within a spreadsheet, and all of this works as expected..

what i am looking to do is send (Ctrl +P) at the end of the macro to bring upthe print dialogue box. i dont want to use the default printer, i want to give the users the ability to select which ever printer they wish to print to.

is this possible? Thanks in advance

Reegards

 

[PHV]

A starting point:
Application.Dialogs(xlDialogPrint).Show

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cosfreelance]

Hi PHV,

That worked ! exactly what I needed .. thanks for your help..

Regards