I discovered this after my work PC was upgraded to 2007, while other PC's in the company were still running 2003

[VBA]
.TintAndShade = 0
[/VBA]

I used the record macro button. to change some formats on a couple of sheets, and this line of code runs fine with 2007,
but any earlier versions, break and explode causing many of my colleagues much distress and anguish.

thoought this might be handy for all.

Mark