This is because Excel flushes all print-job specific settings betwee
sheets, even when in a group selection. This is evidenced in anothe
way that users of Adobe Acrobat will know. If you select a group o
sheets and print to PDFWriter, you get asked for a filename for eac
SHEET (not just for one filename and then it prints all sheets to tha
same file). Therefore, each sheet is being sent as a separate job
just that Excel automatically sends all the jobs at once when in
group selection.
However, there is no way to stop the Printer Preferences getting in th
way between the jobs - so whatever you have set over and above that i
Properties will only hold for the first sheet in the selection.
It's not a bug as such because that's what you would expect to happe
if printing the sheets separately anyway; it's just that Microsoft hav
obviously never got around to making group selections spool to print a
if they were one job - probaby because there are too many counters
pointers, indexes and handles calculated and incremented whils
rendering one worksheet to the spooler to allow other worksheets t
follow on in the same job. Probably too demanding memory and resource
wise.
However, I agree that it is annoying. It is possible to write VB
routines that use a load of SendKeys to access the printer propertie
box, get to the settings required and change them (manufacture
permitting), looping this after selecting each sheet in the boo
individually to print, but it would be of no use posting an exampl
here for one printer, because for another model (even sam
manufacturer), the whole SendKeys string will almost always need to b
different