Printing macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write a macro to first do a Print Preview, then
allow for printer selection by the user and then print
Can anyone give me a hand
I appreciate your help in advance
Louis
 
Low-tech, but:

Sub PreviewAndPrint()
Sheet1.PrintPreview
Application.Dialogs(xlDialogPrint).Show
End Sub
 
Thanks for the tip. It does work. The only problem is that once you are in the print dialogue box the "cancel" button works as an "OK" button as well. Any other ideas? Or should I use a UserVal maybe
Again, thanks for your help
Louise
 
Are you sure? It works as expected on my system.

--

Vasant

Louise said:
Thanks for the tip. It does work. The only problem is that once you are in
Click to expand...
the print dialogue box the "cancel" button works as an "OK" button as well.
Any other ideas? Or should I use a UserVal maybe?
 
Back
Top