Dear Experts,

As I constantly receive from colleagues with Excel workbooks containing variable number of worksheets for printing, and these workbooks may have different print settings.

I wish to have codes written so that I can apply my own set of print options to "all" the worksheets in the workbook with regard to :
1. Print to A4, Portrait (not Landscape)
2. Print to 1 page only
3. Print resolution 600dpi
4. Print top margin 1, bottom margin 1, left margin 1.5, right margin 1.5
5. Print in monotone (no cell coloring)

Many thanks.