Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I got this macro to change the color of the cell pointer from this NG posted
by Mr. Bob Phillips long time ago. The macro works if its in the workbook. Can it be modified so if you paste the macro in your Personal worksheet, it will work on any workbook? Public OldRng Private Sub Workbook_Open() ReDim OldRng(20) 'allow for up to 20 worksheets End Sub Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Dim ThisRng On Error Resume Next Set ThisRng = OldRng If Not ThisRng Is Nothing Then ThisRng.Interior.ColorIndex = xlNone End If Target.Interior.ColorIndex = 6 'yellow Set OldRng = Target End Sub Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
cell pointer content Info | Excel Worksheet Functions | |||
Current contents of the cell pointer? | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |