how create cursor that highlights total row/column at all times

G

Guest

how do i create a cursor that at all times highlights the row/column that i
am working in?
 
B

Bernie Deitrick

Copy the code below, right click the sheet tab, select "View Code" and paste
the code into the window that appears. This will work when you are arrowing
around the sheet, or using your mouse. It won't work if you hit enter to
change the activecell.

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Union(Target.EntireColumn, Target.EntireRow).Select
Target.Activate
Application.EnableEvents = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlighting Entire Row without the Mouse 11
Cursor is highlighting more than one cell 3
Highlighting Active working area 3
highlight cursor row 3
Highlights/changes the column and row appearance as the cursor mov 2
Highlight / Copy down a long row? 2
Highlighting the cursor area 2
Cursor, row, colum, beam 3

Top