View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dickie Worton Dickie Worton is offline
external usenet poster
 
Posts: 24
Default Highlighting the Active Row

Hi,
Having found out how to perform the small miracle that is highlighting the
active row in an Excel spreadsheet at:

http://www.mcgimpsey.com/excel/highlightrow.html

I find I know have a small problem.

The row that is active when the spreadsheet is opened does not reset back to
the previous formatting. This means that although when I click on a different
row it becomes highlighted, changes back when I click to another, etc, the
original row selection upon opening stays highlighted too.

I have had no option but to delete the row from the sheet to remove it, but
I don't want the users of the spreadsheet to have to do this, or even attempt
to!

Does anyone have any suggestions as to what might be going wrong, what I
might have done wrong, etc?

I have inserted the code suggested into a Worksheet:Selection Change, is
this correct?

All help gladly received,

Dickie