VBA to reset Print Options

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.

Thx.
1. Regarding the print resolution, can I actually alter the print resolution say from 300dpi to 600dpi which info seems to be carrying within each worksheet.
2. Because usually I've problem when I receive Excel files with worksheet print resolution in 300dpi, it will cause to print in two pages instead of one page.

Is there anything I can do ?
Thx again.

Great! Everything works fine.
Thanks so much.