I'm trying to print multiple worksheets in color. The default setting of our
printer is black and white, so I highlight all the worksheets, go to file
print, select properties, and change the black and white setting to color.
The first worksheet prints out correctly, but the other sheets use the
default settings of the printer.

As a test I tried doing the same thing, but instead of changing color I told
it to duplex. Once again the first worksheet was duplexed and the rest of
the worksheets were not. I've tested this issue on a HP 4100 and a Canon
Image Runner 4080. Any Ideas?