| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight Row and Column headers of active cell
Hi folks. What I'm going for is highlighting the Row and Column *headers* of the active cell. E.g. if the Active Cell is E5, I'd like the E and the 5 to be highlighted. Presumably the code will be linked to the SelectionChange event, couldn't get anything to work though. Any quick fixes wizards? Regards |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight Row and Column headers of active cell
Alex,
That is the normal behaviour of Excel anyway. In XL2000, the letter/number are Bold, but in XL2002 the header is column/row is in a different colour. Not much you can do about changing that, unless you create your own header columns/rows in A:A and 1:1 and colour those. NickHK "alex.hatzisavas" wrote in message ups.com... Hi folks. What I'm going for is highlighting the Row and Column *headers* of the active cell. E.g. if the Active Cell is E5, I'd like the E and the 5 to be highlighted. Presumably the code will be linked to the SelectionChange event, couldn't get anything to work though. Any quick fixes wizards? Regards |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight Row and Column headers of active cell
Hi Nick, thanks for that. I got Excel 2002. The highlighting of the Column and Rows headers is grey. Any way to turn it into funky orange or sth.? Couldn't find anything under Tools Options. Regards On 5 Feb, 10:43, "NickHK" wrote: Alex, That is the normal behaviour of Excel anyway. In XL2000, the letter/number are Bold, but in XL2002 the header is column/row is in a different colour. Not much you can do about changing that, unless you create your own header columns/rows in A:A and 1:1 and colour those. NickHK "alex.hatzisavas" wrote in message ups.com... Hi folks. What I'm going for is highlighting the Row and Column *headers* of the active cell. E.g. if the Active Cell is E5, I'd like the E and the 5 to be highlighted. Presumably the code will be linked to the SelectionChange event, couldn't get anything to work though. Any quick fixes wizards? Regards- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight Row and Column headers of active cell
Alex,
AFAIK, nothing in Excel. If it's your own system, maybe play with the Control PanelDisplayAppearanceScheme and/or Item. Not sure if XL reads from these settings though. NickHK "alex.hatzisavas" wrote in message oups.com... Hi Nick, thanks for that. I got Excel 2002. The highlighting of the Column and Rows headers is grey. Any way to turn it into funky orange or sth.? Couldn't find anything under Tools Options. Regards On 5 Feb, 10:43, "NickHK" wrote: Alex, That is the normal behaviour of Excel anyway. In XL2000, the letter/number are Bold, but in XL2002 the header is column/row is in a different colour. Not much you can do about changing that, unless you create your own header columns/rows in A:A and 1:1 and colour those. NickHK "alex.hatzisavas" wrote in message ups.com... Hi folks. What I'm going for is highlighting the Row and Column *headers* of the active cell. E.g. if the Active Cell is E5, I'd like the E and the 5 to be highlighted. Presumably the code will be linked to the SelectionChange event, couldn't get anything to work though. Any quick fixes wizards? Regards- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| How do I get row and column of active cell to highlight? | Excel Discussion (Misc queries) | |||
| How do I highlight the active row and column headers? | Setting up and Configuration of Excel | |||
| How to set highlight for the column&row header of the active cell | Excel Worksheet Functions | |||
| How to highlight active row and column? | Excel Programming | |||
Linear Mode
