To run a macro when values of the cells modified?

Hi,

I would need to get a macro running every time when the document is modified.

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
        ByVal Source As Range)

This code would work, but the problem is that the macro edits the cells, and therefore it ends up running over and over again...

Thanks!

This is a simplified example (the actual code runs also a macro which changes the y-axis scales of charts located on their own sheets...).

When I edit the value of a cell, excel gets stuck prompting "hi!" over and over again...

"ThisWorkbook":

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
        ByVal Source As Range)

msgbox "hi!"

muokkaus "hei"


End Sub

and

"Module 1":

Sub muokkaus(hei As Variant)


With Sheets("scatter_25_8")
Sheets("Adjustments").Range("B11").value = .Axes(xlValue).MaximumScale
Sheets("Adjustments").Range("B11").value = .Axes(xlValue).MinimumScale

End With

End Sub

Try this:

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
        ByVal Source As Range)
    Application.EnableEvents = False

'your code

    Application.EnableEvents = True
End Sub

HTH

Jason