Highlight Row & Column of Active cell in large spreadsheets

[chrisb84]

Good Afternoon,

Is there a way to highlight the row and column of the active cell? The highlighting will move as the active cell is moved around the spread sheet. I have a newbie manager that is bugging the pea-turkey out of me! He wants to be able to easily see where he is within some of our sheets while he is in a vehicle or outside on a job site...seems like an "accessibility" type issue, but can't find anything in Excel "Options."

HELP!
chrisb84

[Armando Montes]

Try:

[chrisb84]

This is a new area of Excel for me. How do I incorporate this? Is this a macro function?

[Tank997]

Open the Visual Basic Editor (VBE) with Alt+F11 and double click on "ThisWorkbook" In the file you want to add the code to and paste this code in the main window.

Please Login or Register  to view this content.

You can change the numbers after RGB( to change the color. Good Luck.

[chrisb84]

Tank,

Ran the VBE in a blank, new workbook and it worked perfectly. Then I copied the code in to my "real" workbook and got this error:

Runtime error '1004':
Application-defined or User-defined error

I ran "debug" and this line was highlighted:

Cells.Interior.ColorIndex = xlNone

For me, this is treading in unknown waters.

Thoughts? Do you want me to post up my workbook? It contains tables, graphs, filtering, formulas, and conditional formatting. Could some of this be interferring with the fix you created?

chrisb84

[Tank997]

Chris, I tried the code on several sheets with all the things you described and don't get the error. Upload a sample file where you get the error so we can take a look at it.