Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting Active Cell? How? | Excel Discussion (Misc queries) | |||
Selecting/Highlighting active cells | Excel Discussion (Misc queries) | |||
Highlighting an active cell | Excel Worksheet Functions | |||
Highlighting the active row with special colour | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |