I have a macro I found on this site that I really like. It helps me easily pick select different sheets in the workbook (using check boxs) and sends them to a printer when executed. The only quam I have with the macro is it would be great if one were able to send them to a pre determined printer (other than my normal default printer). I have a PDF creator that is assigned as a printer so it would be nice to have the selected sheets print to that printer versus my default. My goal is to minimize steps in printing. Are there options built into excel that will allow me to do this or will I have to create a new macro or add to the existing one. The marco I have in question is the following, thanks for any and all help;
----------------------------------------------------------------------------------------------------------------------
Bookmarks