Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting row
I have a very large spreadsheet with first and last names
in the first two columns. Is there any way for me tell the spreadsheet to highlight the row I am on when I click on a cell? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting row
This will do as you want, BUT, beware that this effectively disables any undo
levels - so be careful:- http://www.cpearson.com/excel/rowliner.htm -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- wrote in message ... I have a very large spreadsheet with first and last names in the first two columns. Is there any way for me tell the spreadsheet to highlight the row I am on when I click on a cell? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.535 / Virus Database: 330 - Release Date: 01/11/2003 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting row
Check out this
This one from J.E http://www.mcgimpsey.com/excel/highl...iteRetainColor Or Chip Pearson's RowLiner add-in http://cpearson.com/excel/RowLiner.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl wrote in message ... I have a very large spreadsheet with first and last names in the first two columns. Is there any way for me tell the spreadsheet to highlight the row I am on when I click on a cell? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting row
And also see the caveat I gave in my note re undo levels. :-)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "Ron de Bruin" wrote in message ... Check out this This one from J.E http://www.mcgimpsey.com/excel/highl...iteRetainColor Or Chip Pearson's RowLiner add-in http://cpearson.com/excel/RowLiner.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl wrote in message ... I have a very large spreadsheet with first and last names in the first two columns. Is there any way for me tell the spreadsheet to highlight the row I am on when I click on a cell? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.535 / Virus Database: 330 - Release Date: 01/11/2003 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting row
Hi Ken
my note re undo levels Most macro's have that problem But maybe a note about this on the sites is a suggestion for J.E and Chip -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Ken Wright" wrote in message ... And also see the caveat I gave in my note re undo levels. :-) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "Ron de Bruin" wrote in message ... Check out this This one from J.E http://www.mcgimpsey.com/excel/highl...iteRetainColor Or Chip Pearson's RowLiner add-in http://cpearson.com/excel/RowLiner.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl wrote in message ... I have a very large spreadsheet with first and last names in the first two columns. Is there any way for me tell the spreadsheet to highlight the row I am on when I click on a cell? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.535 / Virus Database: 330 - Release Date: 01/11/2003 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting row
Wow! Thanks it works great. But, how do I make it work
when the spreadsheet is protected?? PS I am the person who protected it, but I want it protected when others use it. -----Original Message----- This will do as you want, BUT, beware that this effectively disables any undo levels - so be careful:- http://www.cpearson.com/excel/rowliner.htm -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------- ------------------ Attitude - A little thing that makes a BIG difference ---------------------------------------------------------- ------------------ wrote in message ... I have a very large spreadsheet with first and last names in the first two columns. Is there any way for me tell the spreadsheet to highlight the row I am on when I click on a cell? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.535 / Virus Database: 330 - Release Date: 01/11/2003 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlighting | Excel Discussion (Misc queries) | |||
HIGHLIGHTING | Excel Worksheet Functions | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Highlighting | Excel Discussion (Misc queries) | |||
Highlighting changes | Excel Discussion (Misc queries) |