I'm hoping that someone can suggest a way round this...
I have quite a large codebase which uses cell colours as meta-information about the cell for processing purposes. This worked fine in Excel 97/2000/2003 but the new theme engine in Excel breaks it.
I can set cell colours in VBA fine, but the users no longer have the standard colour chart to select from. Fine I thought, create a custom theme for them so that the colours match my internal colours.
Sadly this doesn't work as changing themes changes all the interior.colorindex numbers, in some cases exchanging their meanings to my code.
Can anyone think of a way round this please? Changing theme should be a display layer function, not playing with internal values. thanks
I have quite a large codebase which uses cell colours as meta-information about the cell for processing purposes. This worked fine in Excel 97/2000/2003 but the new theme engine in Excel breaks it.
I can set cell colours in VBA fine, but the users no longer have the standard colour chart to select from. Fine I thought, create a custom theme for them so that the colours match my internal colours.
Sadly this doesn't work as changing themes changes all the interior.colorindex numbers, in some cases exchanging their meanings to my code.
Can anyone think of a way round this please? Changing theme should be a display layer function, not playing with internal values. thanks