how do i restrict cells to not accept formulas?

[John]

Is there a way to restrict cells in excel so that formulas cannot be typed
into them?

 

[Don Guillett]

Right click sheet tab>view code insert this>you may want to restrict the
area??

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.HasFormula = True Then Target = ""
End Sub
or
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.HasFormula = True Then
MsgBox "No formulas allowed"
Target = ""
End If
End Sub

 

[Don Guillett]

Or this to convert their formula to a value

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.HasFormula = True Then
Target.Value = Target
msgbox "Your formula has been converted to a value"
End If
End Sub

 

[ryguy7272]

Well, I guess you could use Data Validation. Data > Validation > Custom > in
the rectangle, put this: =$C$1.

In Cell C1, enter this: <>=

Try that and see how you get along.

HTH,
Ryan---