I have a workbook that contains multiple sheets of which I would like to automate the printing process for several of them.
I would like to be able to have several buttons on the cover page (just the first worksheet) where I can select to print each of the worksheets (ie 1 button for each) and then another button to print all of them (by all of them I really mean a selection of multiple worksheets).
I would also like to be able to select the printer that is used as on some occasions a normal printer will be used but at other times a pdf writer "printer" will be required.
Is there code that can be used to bring up the print prompt for the individual worksheet buttons? I can code to select the print area but not to bring up the print prompt. I can only set it to print the print area to the default printer.
Also in order to print a series of worksheets (only the first page on each), would it be best to basically run the code for each of the individual ones in another function or is it possible to set the print area over multiple worksheets.
I apologise for the length of the query. Thanks for reading all the way through!
I appreciate any help or ideas