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
raceproretiredAsked:
Who is Participating?
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
0
raceproretiredAuthor 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
0
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.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

raceproretiredAuthor 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
0
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
0

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
raceproretiredAuthor Commented:
Thanks Tom,
It works well :)
Ian
0
tomfarrarCommented:
Glad to hear it.
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.