Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is a Macro for 'Highlighting The Active Cell' that will change
the background color of the ActiveCell to yellow anytime you select a new cell, either with the mouse or with the arrow keys. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) Static OldRange As Range On Error Resume Next Target.Interior.ColorIndex = 6 ' yellow - change as needed OldRange.Interior.ColorIndex = xlColorIndexNone Set OldRange = Target End Sub The author says that if one wants to make the active cell appear in a special color, use the following this code in the Workbook_SheetSelectionChange event of the workbook. BUT, I am not good with VBA or Macros yet so I do not know what he means ... How do I get this Macro to work? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Active cell/row highlighting | Excel Discussion (Misc queries) | |||
Highlighting row of active cell question | Excel Discussion (Misc queries) | |||
Highlighting Active Cell | Excel Discussion (Misc queries) | |||
Highlighting Active Cell? How? | Excel Discussion (Misc queries) | |||
Highlighting an active cell | Excel Worksheet Functions |