Scott
The following Worksheet_Change event macro will do what you say you
want. As long as the formula stays in that cell (B1 as written now) the
macro will not fire when the dependent values change resulting in a change
in the value displayed in B1. But if a value is entered in that cell,
replacing the formula, the macro will fire. Post back if you need help with
setting up this macro with your data.
Note that this macro has to be placed in the sheet module for the sheet
that contains that cell. To do this, right-click on the tab of that sheet,
select View Code, and paste this macro into that module. Click on the "X"
at the top right of the screen to return to your spreadsheet. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) < "B1" Then Exit Sub
MsgBox "It changed."
End Sub

"scott" wrote in message
...
I have a cell that has a formula entered into it. At certain times in the
month of operations this cell with the formual needs to be replaced with a
meter reading. I have the worksheet protected expcept for this cell so
people
can enter in the reading.ow is there another formual or way to tell when
this
formula has been replaced with the reading, maybe in the form of another
formula in another cell.
Thanks in adavance
Scott