Macro to choose printer

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.
 
B

Bob I

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

SendKeys ("%FP")


after the last recorded step to do a File, Print.
 
D

Don Guillett

Try incorporating something like
application.Dialogs(xlDialogPrinterSetup).Show
ActiveWindow.SelectedSheets.Print
 
Top