I have a master spreadsheet that all users use to input operational
data. Some users try to duplicate inputs by using equal signs and
referencing similar data. Is it possible to prevent users from
creating/inputting formulas?


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=484105

TEAM.
How about:

Private Sub Worksheet_Change(ByVal Target As Range)
'If InDebugMode=False then
With Target
If .HasFormula = True Then
MsgBox "No formulae allowed"
.Value = ""
.Select
End If
End With
'EndIf

NickHK

"TEAM" wrote in message
...

I have a master spreadsheet that all users use to input operational
data. Some users try to duplicate inputs by using equal signs and
referencing similar data. Is it possible to prevent users from
creating/inputting formulas?


--
TEAM
------------------------------------------------------------------------
TEAM's Profile:
http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=484105