How do I restore Cell Background Color in VB Script while using Excel

I am supporting with some seniors on voluntary basis for a non profit organization.
Some of them have difficulty to identify the active cell . So I followed the instruction as per YouTube

Please Login or Register  to view this content.

The important script I am using is

Please Login or Register  to view this content.

This works perfectly fine for highlighting the active cell. Basically it will highlight active row, active column and active cell background in different color.
Unfortunately while moving from one cell to another cell, the background color of active row, column and cell is reset to normal.
How do I restore the background color?

So basically If my understanding is correct before entering the cell, I need to store the current background of row, column and cell in a variable. while leaving I should restore back.
I am not sure how do I read? what function I should store? what function I should restore?
Since I am new to VB Script, request your help.

Thank you

I'm not sure I understand what you want to do. Do you not want to re-set the background color of the selected row, column and cell to normal when you move from one cell to another cell? It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

I'm still not sure of what you mean by

without resetting the Background of Row, Column and Cell colors

Your macro is located in the code module for ThisWorkbook which means it will run for every sheet in the workbook. If you want it to run only for one sheet, try this macro in the code module for the desired worksheet. See if it does what you want. If not, please explain in more detail what you mean by

without resetting the Background of Row, Column and Cell colors

Please Login or Register  to view this content.

Thanks Mumps1 for your quick response.

The Volunteers (Mostly Senior Citizens) will have excel file like "Sample Without Active Cell Highlight.xlsx"
In this excel file lots of data. Some rows, columns and cells are marked in different colors. (As shown in below example)
Please check the file
[

Please Login or Register  to view this content.

In the above example,Active cell, Active Row, Active Column is not highlighted clearly, this Senior Citizens who are working on the excel sheet have difficulty to identify which cell currently active.

IMAGE B: Worksheet which highlight Active Row , Active Column and Active Cell But it resets the earlier marked background colors

So after Executing Above VB Script, the Active Row, Active Column and Active Cell is clearly highlighted, But the VB Script code removes the earlier background marked active row, column and cell colors.
So we want to restore the Highlighted colors in first file in addition to show active row, active column and active cell.

So we want to restore the Highlighted colors in first file in addition to show active row, active column and active cell.

So you want to keep the previously highlighted active row, active column and active cell when you click on a new cell. If this is correct, the macro I suggested in Post #4 should work for you.

I tested the macro on the file you posted. Please look at the attached file and note cells C4, I18 and N12. These are the cells I clicked. You will notice that the intersecting row and column of each of the cells is highlighted in light blue and the C4, I18 and N12 are highlighted in light purple. My understanding is that is what you wanted. If not, please use the file "Sample Without Active Cell Highlight.xlsx‎" that you previously posted and manually highlight the cells and intersecting rows and columns for the same 3 cells I used so I can see what your end result should look like and post the file.