I have a macro that I need to run when ever a calculation is performe
on the activesheet.

I am using the following code, in the workbook object to carry tha
out:

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

With ActiveSheet

SheetNumberUpdate

End With

End Sub

It does fire when the calculation occurs and runs the macro, howeve
once it continues to run cycling back through the macro. Lather
rinse, repeat!

I tried placing the above code in the module with the macro but then i
doesnt work at all.

Help!!!!!!!!!

--
Hammer_75
-----------------------------------------------------------------------
Hammer_757's Profile: http://www.excelforum.com/member.php...nfo&userid=741
View this thread: http://www.excelforum.com/showthread.php?threadid=40046