Hi,

If you go to 'File - Options - General', you can set the Color Scheme of
Excel.

In XL2010, you can select 'Blue', 'Silver' or 'Black'.
In XL2013, the options are 'White', 'Light' or 'Dark'.


This raises two questions:

Question 1:
Why on Earth has Microsoft changed this?!?
What the idea? What's the logic?
Why not just add more options instead of totally chage these?!?


Question 2:
Is there any way in VBA to read/get/find out, what Color Scheme the user is
using?!?
I know, I can read it from the Registry, but even both the key and the
values are different from version to version.

In XL2010, the key is 'Theme', and the values are 1=Blue, 2=Silver and
3=Black'
In XL2013, the key is 'UI Theme', with the values are now going from 0 to 2.

I don't get it?!? What's the logic?!?

And, even if I decide to read the Registry, I can't be sure MicroBRAIN isn't
changing it again in the furture!!!

How to fund out what Color Scheme the user is using?!?


TIA,

CE





---
Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret.
http://www.avast.com