foid025


Hello all,
I am trying to get a macro done that prints a sheet in a workbook. Up till now, I have been using the ActiveSheet.PrintOut function to do this. However, I want to give the user printing options. So the best thing I could do was use ActiveSheet.PrintOut Preview:=True, which at least allows the user to manipulate the page formatting and zooming.

However, this doesn't allow the user to choose a printer (it just prints on the default printer). Is there a function I can use that will just load the default Excel print window (the one that you see when you hit Ctrl + P) I have no doubt that there is such a function, but I have no idea how to find it...

Thanks a lot.




Re: Showing the printing window in Excel to print a spreadsheet.

MyLady


Hey,

Here you go¡­

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

Best Regards

Cathrine






Re: Showing the printing window in Excel to print a spreadsheet.

foid025

Perfect. Thanks Cathrine!