Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing from a Macro!

Status
Not open for further replies.
May 31, 2007
31
AE
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
 
A starting point:
Application.Dialogs(xlDialogPrint).Show

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

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

Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top