Although the suggestion I posted indeed applies or removes borders to the
Normal style, it doesn't change any cell formats including borders. IOW,
toggles white fill & grey borders on/off in the entire workbook, and
automatically depending on users settings if required. The only
inconsistency I can think of is if you apply a fill colour format normally
that will hide Excel's gridlines, but the grey borders in the Normal style
will persist. Apart from that I would have thought it was a simple and
effective solution to the problem you described.

Regards,
Peter T

"canbya" wrote in message
ups.com...
No go, to all the suggestions. Still the lime green.
It was too messy to make the cells white and add gridlines. There were
border colors on some rows.

I ended up restoring the databases and recreating. Gotta love backup.
Thanks for your help.
E


NickHK wrote:
If it is the background as Tom suggests, it will not print, so
PrintPreview
should give you a white background.
Does it ?

NickHK

"canbya" wrote in message
oups.com...
Thanks for your help.

Cells.Interior.ColorIndex = xlNone

This does not affect the green. Also, if I try to set it to white, I
loose the gridlines,


If you are talking about Windows Theme colors, then that is a whole
different story and probably should not be tackled within Excel.

Yes, I did reset this person's advanced appearance | window | color1
immediately upon catching this. But I am faced with 12 green workbooks
with many worksheets each that cannot be regenerated (they were made
from a live database several weeks ago).

So do you know a way outside VB to fix these sheets?
E