M
Michiel via OfficeKB.com
Can Anyone shine a light on this:
I have a worksheet and did this:
activecell.Interior.ColorIndex =40
The cell became salmon orange as I would expect it.
I received another version of the same spreadsheet saved by a colleague.
All the cells that are salmon-orange in my sheet turn out to be grey in his
sheet.
When I select a grey cell and run:
?activecell.Interior.ColorIndex
again 40 is returned.
Even if I once more run
activecell.Interior.ColorIndex =40
the cell stays grey.
So, I have two sheets, both with cells that have an interior.colorindex of 40
but they show different colors.
Additional:
When I go to the Fill Color or Font Color icon in my colleagues sheet and hit
the arrow I get a palette that again differs from the palette I get in my own
sheet.
Is there some parameter that controls the general look of the palette and the
connected behavior of the color index coding?
Thanks!
Michiel
I have a worksheet and did this:
activecell.Interior.ColorIndex =40
The cell became salmon orange as I would expect it.
I received another version of the same spreadsheet saved by a colleague.
All the cells that are salmon-orange in my sheet turn out to be grey in his
sheet.
When I select a grey cell and run:
?activecell.Interior.ColorIndex
again 40 is returned.
Even if I once more run
activecell.Interior.ColorIndex =40
the cell stays grey.
So, I have two sheets, both with cells that have an interior.colorindex of 40
but they show different colors.
Additional:
When I go to the Fill Color or Font Color icon in my colleagues sheet and hit
the arrow I get a palette that again differs from the palette I get in my own
sheet.
Is there some parameter that controls the general look of the palette and the
connected behavior of the color index coding?
Thanks!
Michiel