G Guest Sep 12, 2007 #1 How can i have the data in a cell only be shown when the curser is clicked on that cell or the curser is placed over the cell?
How can i have the data in a cell only be shown when the curser is clicked on that cell or the curser is placed over the cell?
G Guest Sep 12, 2007 #2 In sheet-tab codemodule Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("D2")) Is Nothing Then Range("D2").Font.ColorIndex = 2 Else Range("D2").Font.ColorIndex = 1 End If End Sub "DMK" skrev:
In sheet-tab codemodule Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("D2")) Is Nothing Then Range("D2").Font.ColorIndex = 2 Else Range("D2").Font.ColorIndex = 1 End If End Sub "DMK" skrev:
