Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how prevent formula in cell from deleting when deleting value????
example: =sum(a1-b1-c1) answer and formula in cell d1
if i delete the answer to this formula in cell d1 it also deletes the formula. i want the formula to stay in the cell d1 how can formula be locked or protected in cell d1 and still make and delete value entries in cell d1 ????? |
#2
|
|||
|
|||
Your message isn't very clear. If you want the formula to remain in D1,
then it will continue to calculate. If you mean that you want to override the formula, but have it return if you delete the value used to override it, that will require an event macro. One way: Put this in your worksheet code module (right-click the worksheet tab and choose View Code): Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Count 1 Then Exit Sub If .Address(False, False) = "D1" Then If IsEmpty(.Value) Then Application.EnableEvents = False .Formula = "=A1-B1-C1" Application.EnableEvents = True End If End If End With End Sub (Note that the SUM() in your formula is superfluous). In article , "sh-boom" wrote: example: =sum(a1-b1-c1) answer and formula in cell d1 if i delete the answer to this formula in cell d1 it also deletes the formula. i want the formula to stay in the cell d1 how can formula be locked or protected in cell d1 and still make and delete value entries in cell d1 ????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
How do I prevent incorrect formula results appearing in cell? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |