View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default how do I make the cursor appear as a coloured outline box?

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


On Wed, 16 Nov 2005 07:29:14 -0800, "MikeB"
wrote:

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?