Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
just me
 
Posts: n/a
Default how create cursor that highlights total row/column at all times

how do i create a cursor that at all times highlights the row/column that i
am working in?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick
 
Posts: n/a
Default how create cursor that highlights total row/column at all times

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



"just me" <just wrote in message
...
how do i create a cursor that at all times highlights the row/column that
i
am working in?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiply hours/minutes times dollars for total dollar amount Anakin0303 Excel Discussion (Misc queries) 1 December 12th 05 06:43 PM
sum of total hours not correct Bruno Lauwers Setting up and Configuration of Excel 9 September 6th 05 08:03 AM
How do i get excel to add a range of times & display as total as . pm_faery Excel Discussion (Misc queries) 2 May 10th 05 05:51 PM
How do I sum times to get a total hour value? If I add up to 24 h. Mico Excel Discussion (Misc queries) 2 December 20th 04 01:25 AM
Whats the function to count the total times a word is displayed Monk Excel Discussion (Misc queries) 3 December 10th 04 10:39 PM


All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"