Ian Bell
asked on
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
if all the cells have borders.?
Active cell meaning the cell where mouse is clicked on.
Thanks
Ian
ASKER
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
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
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.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Tom,
It works well :)
Ian
It works well :)
Ian
Glad to hear it.
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