Active cell border

Is there a way I can change the colour of the border of the active cell. It is hard to notice
if all the cells have borders.?
Active cell meaning the cell where mouse is clicked on.
Thanks
Ian
Ian BellretiredAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tomfarrarCommented:
See this link for possible solutions.  Though it is not just border color, but cell color the code could be modified I'm sure.

http://www.atlaspm.com/toms-tutorials-for-excel/toms-tips-for-excel-color-the-active-cell-row-or-column/

I added the "Cell Only" code to the attached spreadsheet so you can see how it might work.  Two issues (I think): the code needs to be added to any tab you want the coloring of active cell to occur, and the workbook needs to be saved as a macro workbook.
EE.xlsm
Ian BellretiredAuthor Commented:
Hi Tom,
Thanks for the link.
Your idea re cell colour was better. However when I copied the code and opened the sheet the
already coloured cells returned to white colour.
I wondered if you could possibly code your attached sheet. I've coloured the cells
and would like the active cell to be any colour, maybe white would be best.
What do you think ?
Thanks
Ian
EE.xlsm
tomfarrarCommented:
Are you saying you already have colored cells in your spreadsheet you want to leave colored?  The code I sent you (and it isn't my code) first changes all cell colors to white, then highlights the active cell in the blue/green color.
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

Ian BellretiredAuthor Commented:
Yes, they are all coloured and would like to keep them this way. The cells have borders.
I would like the active cell to somehow stand out that is why I wanted a border change to white or the active cell background to change to white.
At the moment the active cell is hard to identify as I use black borders.
Another idea is it possible to have a thick black border around the active cell ?
Thanks
Ian
tomfarrarCommented:
I am working with others here to get the answer you are looking for.  Attached are two options, one of which seems to work fine and one that needs a slight tweak.

Option 1 - Requires the original color ranges to be defined in size and color.  Other than that, it seems to do what you are asking for.  Once the range and color are correctly entered into the macro, you should be good to go.

Option 2 - Works without entering range and color, but when you finish, and come back to the page later, the last cell selected still remains white.  I have asked for help on this.  

Let me know what you think.  - Tom
Copy-of-EE.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ian BellretiredAuthor Commented:
Thanks Tom,
It works well :)
Ian
tomfarrarCommented:
Glad to hear it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.