I have created and set up a number of daily reports that mulitple
users can generate from multiple work stations.

All of the work stations are on the network, the workbooks that
generate the reports are on a network drive and all the printers are
on the network.


Different workbooks print to different printers (some color / some
B&W) and some print single sided while others duplex.


This is the cause of my frustration. Although I have set all the
page
properties, workbook properties, and print setups and saved them,
they
tend to wander. Perhaps someone has gone into the properties or
switched a workbook to another printer but for whatever reason these
settings seam to wander and then I have a one-sided job that prints
duplex or vice versa.


Is there a macro instruction I can use to desginate one-sided or
duplex printing and eliminate the problems.


Thanks in advance for your assistance.

Don