how do I make the cursor appear as a coloured outline box?

M

MikeB

I have been sent a spreadsheet in which the cusor appears as a green outline
box around the cell. how is this done as i can't find any reference in Help
etc?
 
G

Gord Dibben

Mike

Perhaps some worksheet code like the following?

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
Set OldCell = Target
End Sub

Right-click on the sheet tab and "View Code". See if any code in that module.

OR could be some code in the ThisWorkbook Module.


Gord Dibben Excel MVP
 
Top