Pop Up Message = Cell

[Wayne]

Having tried to protect a cell that has a formula and
also having a comment attached to the cell saying "If you
want to type in this cell go to Sheet1 cell..Etc and type
there..." Does anyone know some code so that...

If someone tries to type in a cell then it produces a pop
up message?

 

[Paul B]

Wayne try this in the sheet code

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then
If ActiveCell.HasFormula Then
MsgBox ("If you want to type in this cell go to Sheet1 cell..")
Else
End If
End If
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **