How can I change header column backcolor?

[Spooman]

I started on this matter as a reply to a previous thread, but truth be told, I should have started a new thread as the matters were unrelated, so here goes...

I'm trying to mimic the row and col "active color" from grey to gold, as seen in this thread
http://www.vbforums.com/showthread.p...41#post5204641

I like the gold





This is what mine looks like



In my case, the "9" and the "3" (row and col) have darker-grey background.
Is it possible to go for the gold?

EDIT-1

BTW, I'm using 2016 (the preset listbox only goes up to 2013 .. )

Also, the gold appears to apply to all "selections"
.. row, col designation
.. "Design Mode" selection
.. "More Controls" selection .. Microsoft External Item Picker

How to do?

Spoo

[Spooman]

Just to clarify ..

How do I get my "grey" header 1 (row) and 1 (col) highlights


to be "gold" header 1 (row) and A (col) highlights?

with the latter image coming from here
http://www.vbforums.com/showthread.p...eparate-colors

Spoo

[westconn1]

i think maybe it is a specific version of excel (possibly 2007), that has the gold

afaik it is not possible to change, there are many work arounds, but none are really satisfactory, maybe you can subclass the excel application window

[Spooman]

Pete

Thanks. In addition to 2007, there are 2 confirmations for version 2010 in the link in my OP. Not sure what version RobDog had, but given that his post was in 2007, that could be a candidate as well ..

I was hoping that there might be a Style setting somewhere that enabled one to change the "look and feel".

Subclassing is currently beyond my pay grade .. maybe at a later date.

Any thoughts as to how I could track down some of those workarounds?

Spoo

[westconn1]

Any thoughts as to how I could track down some of those workarounds?

just google on it, but most involve changing cell(s) colour in selection change event of the worksheet, nothing to do with what you actually want to achieve

from some other forum, also with no real solution

In 2010 when I select a group of cells the column/row headers are yellow. How can I change this? Yellow is a migrane trigger and I spend hours each day working in Excel. I believe I changed it in 2007 as when I do this same selection in 2007 the headers are orange

i have never used excel 2007 and only rarely 2010

Subclassing is currently beyond my pay grade .. maybe at a later date.

maybe ask in the vb forum if anyone can help to do

[Spooman]

Pete

Thanks for those thoughts.

Spoo