If a cell range = field in this case then:
Right click on your sheet, select view code and paste the following:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:b1000")) Is Nothing Then
application.run("LMF's Macro Name")
end if
end sub
Might want to change your target to something more pertinent to your worksheet.
_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
This message was edited by NateO on 2002-03-19 10:05