Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i restrict cells to not accept formulas?
Is there a way to restrict cells in excel so that formulas cannot be typed
into them? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i restrict cells to not accept formulas?
Right click sheet tabview code insert thisyou 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 Microsoft MVP Excel SalesAid Software "John" wrote in message ... Is there a way to restrict cells in excel so that formulas cannot be typed into them? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i restrict cells to not accept formulas?
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 -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... Right click sheet tabview code insert thisyou 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 Microsoft MVP Excel SalesAid Software "John" wrote in message ... Is there a way to restrict cells in excel so that formulas cannot be typed into them? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i restrict cells to not accept formulas?
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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "John" wrote: Is there a way to restrict cells in excel so that formulas cannot be typed into them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Where is the Accept Labels in Formulas Option? | Excel Discussion (Misc queries) | |||
how do i restrict users from changing my formulas | Excel Discussion (Misc queries) | |||
Format cells to only accept numbers | Excel Discussion (Misc queries) | |||
change default setting of accept labels in formulas | Excel Discussion (Misc queries) | |||
Won't accept labels in formulas | Excel Discussion (Misc queries) |