I am trying to run some code (post date & time) on a worksheet evert time
any data changes in the sheet. I used the code below

Private Sub Worksheet_Change(ByVal Target As Range)

Worksheets("2008").Range("M7").FormulaR1C1 = "=TODAY()"

' Worksheets("2008").Range("N7").FormulaR1C1 = "=NOW()"

End Sub

I tried TODAY and NOW they both work when the sheet changes. However they
also activate every time I open the sheet. Just opening the sheet posts the
current date and time. I only want the last time data changed on the sheet to
change the time. Note I am not using the WORKSHEET OPEN or ACTIVATE
dropdown box I am using WORKSHEET CHANGE option. Please advise
Thanks
--
Thank You
RVF