Each worksheet has it's own page setup.
File, Page Setup, Sheet, Remove Print B&W only
You can group the sheets, to make the change to only that item,
but be very careful that you ungroup the
sheets afterwards as any change made to one would be made to all
and you could destroy your data. But then I guess you are already
familiar with that if you are grouping sheets to print.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> I am having the same problem - did you get an answer from anyone?
>
[quoted text clipped - 3 lines]
> >
> > Somebody have a idea.