You can prevent the user from selecting the cell in the first place.
Right-click the sheet tab, select View Code, enter this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$9" Then '<===change this if you wish
Range("A1").Select
End If
End Sub

Bob Umlas
Excel MVP

"gav meredith" wrote in message
...
hi,

Is it possible within an excel sheet, to use an 'if' statement to protect
a
cell?? ie if B91, "inc"....but i dont want the user to be able to alter
that cell because if they delete it, they will delete the formula.

Any suggestions are appreciated.Thanks!!!!!