For auto hide and unhide. Right click on the sheet tabView Code and paste
the below code. Change the range accordingly. The below works in A1:J30 range.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1:J30")) Is Nothing Then
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
If Not Target.Comment Is Nothing Then
Target.Comment.Visible = True
End If
End If
End Sub

PS: Set the Security level to low/medium in (Tools|Macro|Security).

If this post helps click Yes
---------------
Jacob Skaria


"wjs2ps" wrote:

Is there a way to add instructions to a cell and have it appear "in the
background" when the cell is selected, then disappear when text is typed?
For example, "Type last name, press TAB".