AUTO HIGHLIGHT ROW & COLUMN

[DHAWAL]

Hi,
Can you provide macro to highlight active row and column. The highlight will move along with cursor. This macro can be available in All sheets and all excel files. Is it possible to make this macro available on Excel Ribbon along with option or button to make this macro ON & OFF. How it can be added to ribbon and turn it on and off.

Please guide.

 

[James006]

Hi,
You can test

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
    Cells.Interior.ColorIndex = xlNone
    Target.EntireRow.Interior.ColorIndex = 36
    Target.EntireColumn.Interior.ColorIndex = 36
Application.ScreenUpdating = True
End Sub

 

[sucre0]

Hi,
You can test

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
    Cells.Interior.ColorIndex = xlNone
    Target.EntireRow.Interior.ColorIndex = 36
    Target.EntireColumn.Interior.ColorIndex = 36
Application.ScreenUpdating = True
End Sub

Hello James006

I found the code very useful. It shows the highlighted rows without "breaks/delays" when moving up/down in inmovilized columns.

Is it possible that you add/modify the code to enable the CTRL+Z function to be invocated by the user?
With that, user will be able to undo manual edition made by user (the active row/column would remain highlighted)

Regards,

 

[Peter_SSs]

Is it possible that you add/modify the code to enable the CTRL+Z function to be invocated by the user?

Have a look at post #4 here

 

[sucre0]

Hello Peter!

Thanks! It was an effective suggestion. The code reduced that "alignment delay/break" of the highlighted row in the immobilized columns area when moving up/down the highlighted row.

Previously, I tested methods to avoid that "delay/break" (preserving undo function), and it seems to be so (by default in excel), because there are immobilized columns, where takes place the beginning of the highlighted row deployment.

For verifying that default issue in excel: maintain pressed the up/down key, the highlighted row will show "delay/break" of alignment in the immobilized Columns area, but a perfect alignment when there are not immobilized columns

Regards,

José Luis