Excel 11 for mac, OSX.8.3
There are several worksheets in a workbook with different page sizes and orientation, and are printed on different printers on a regular basis.

Excel do not remember the page setup for each worksheet. Whenever a worksheet is to be printed, one has to follow clicking:
Com + P > Page Setup > Options > 1.Format for …select printer & Paper size, then ok, ok, then select printer options like color/B&W etc, and finally click on Print. This is a continuously repeating task.

Can this be automated with a vba code ?
I do not possess any vba knowledge. Any help will be highly appreciated.