Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The macro below changes the cell pointer color. However,
it only works on A sheet in a workbook. I need the macro to work in ALL the sheets in the workbook without pasting the macro on all worksheet modules. Public OldRng As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not OldRng Is Nothing Then OldRng.Interior.ColorIndex = xlNone End If Target.Interior.ColorIndex = 6 Set OldRng = Target End Sub Please edit MACRO to work on all sheets. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Record Macro and Edit Macro options disabled | New Users to Excel | |||
Protect but Allow Edit Ranges in Multiple Sheets | Excel Discussion (Misc queries) | |||
Edit Sheets in Excel Addin | Excel Discussion (Misc queries) | |||
I cannot edit work sheets on excel but i can view them. | Excel Worksheet Functions | |||
Emailing Sheets Code Edit | Excel Programming |