Highlighting selected row/column

Searching for a highlighter that does the following:

* limit selection, which means not selecting below or to the right of the selected cell.
* be transparent, not erasing any cell colors
* change automatically when selection changes

Highlight-Active-Cell-Code-310x165.png


Found a highlighter on Microsoft homepage.
When running code below in a worksheet (code for highlighting selected row and column), it firsts asks me to choose a name for another macro.
But I can only choose names for other macros already created, not create a new name for this macro. I want this macro to activate by itself when I open the document.

Please Login or Register  to view this content.

Place the following code in ThisWorkbook Module, not in standard module or sheet module. To do that, double click ThisWorkbook from the project explorer on VBA editor and paste the following code into opened code window.

Please Login or Register  to view this content.

That is what your code for Worksheet_SelectionChange does. It is triggered automatically with the selection. So why would you need that code with Workbook_Open event?

The problem is that when I use Worksheet_Selection is that it doesn't activate automatically, and when I press F5 it asks me to select an already existing macro name.

Tried to insert code both as module, in sheet and in workbook.

Would like something like this, with transparent yellow.

Highlight-Active-Cell-Code-310x165.png

Where have you placed that code? The code for selection change event should be placed on the Sheet module. Right click the Sheet Tab --> View code and paste the code from your post#1 into the opened code window.

Can you upload the workbook in question?

In the attached, I have placed your code on Sheet1 Module. Let me know if that works for you.

Well that is something strange.
1) Did you enable the macros when you opened the downloaded file?
2) Can you run any code from a standard module?

Open VBA editor by pressing Alt+F11.
Now open Immediate Window by pressing Ctrl+G
In the immediate window, type ?Application.EnableEvents and hit enter. What do you get True or False?

That's why your code was not running.
Now in the Immediate Window, type Application.EnableEvents=True and hit enter and see if the selection change event code works for you.