I've been all over the internet and haven't been able to stumble on the answer I'm looking for. I have a macro that does the page setup and sets the active printer. I display the print preview so the user can check it. When the user clicks Print from the preview menu I want the macro to skip the xlDialogPrint and just print to the vba assigned printer. I do not want an extra input box after the print preview is closed.
Basically if the user likes the preview just click print in preview menu and skip xlDialogPrint. If the user doesn't like the preview just click Close from the preview menu.
Any suggestions?
Basically if the user likes the preview just click print in preview menu and skip xlDialogPrint. If the user doesn't like the preview just click Close from the preview menu.
Any suggestions?