Morning all, hoping somebody could assist with a small query I have.
I have a workbook with a button that allows me to select worksheets that have been filled out and send them to the printer. At the moment it will print to whatever the default printer is set to. I use the below code to print the active worksheet;
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Is it possible I can specify what printer to use. I have tried using the 'To' command but this just does nothing.
I also need to be able to specify what sheets to print out. Is it possible to print a sheet by its name?
Thanks for any help in advance.
Jon
I have a workbook with a button that allows me to select worksheets that have been filled out and send them to the printer. At the moment it will print to whatever the default printer is set to. I use the below code to print the active worksheet;
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Is it possible I can specify what printer to use. I have tried using the 'To' command but this just does nothing.
I also need to be able to specify what sheets to print out. Is it possible to print a sheet by its name?
Thanks for any help in advance.
Jon