Macro to choose printer

  • Thread starter Thread starter cab58
  • Start date Start date
C

cab58

I need a macro that selects specific sheets, goes to FILE, then PRINT.
and stops there. THe user will choose the printer.

The macro editor won't allow me to stop recording once I've chosen
print.

Any help would be appreciated.

thanks.
 
Stop the macro after the sheets are selected, Edit the Macro, insert

SendKeys ("%FP")


after the last recorded step to do a File, Print.
 
Try incorporating something like
application.Dialogs(xlDialogPrinterSetup).Show
ActiveWindow.SelectedSheets.Print
 
Back
Top