Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change highlight color on active cells
How do I change the active highlight color of an active cell.
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change highlight color on active cells
Louis
Only though VBA. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Static OldCell As Range If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone End If Target.Interior.ColorIndex = 6 'yellow Set OldCell = Target End Sub This is sheet event code. Right-click on the sheet tab and "View Code". Copy and paste into that module. Chip Pearson has a great add-in named Rowliner.xla that will make the highlighting available for all sheets and workbooks. The code above was cribbed from Chip to start with. http://www.cpearson.com/excel/RowLiner.htm Gord Dibben Excel MVP On Tue, 22 Nov 2005 09:11:09 -0800, "Louis" wrote: How do I change the active highlight color of an active cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Cells no longer highlight when selected | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |