| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change color of active cells
Does anyone know if there is a way to change the color of active cells?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change color of active cells
Put the following in Worksheet code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 Selection.Interior.ColorIndex = 6 End Sub REMEMBER; Worksheet code, not a standard module. -- Gary''s Student gsnu200711 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change color for active row numbers and column letters | Excel Discussion (Misc queries) | |||
| How to change the active cell outline indicator color in Excel? | Excel Discussion (Misc queries) | |||
| change highlight color on active cells | New Users to Excel | |||
| Active Row Column Color Change | Setting up and Configuration of Excel | |||
| How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
