Try this

Place the code in the Sheet module

Right click on a sheet tab and choose view code
Paste the code there
Alt-Q to go back to Excel

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("D11") < 4 Then
testsub
End If
End Sub

Sub testsub()
MsgBox "Hi"
End Sub



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Pete" wrote in message ...
I want to be able to run a existing macro on a spreadsheet
I created, based on the information in cell "D11" being <
4.

I know this can be done, but I am not sure what the code
should look like in order for it work properly.

One note that I don't know if it matters or not, but cell
D11 has a formula assigned to it.

Any help is appreciated
Pete