how to make macro automatically run after modifying spreadsheet

Posted by Kevin on June 13, 2001 7:40 AM

Is there any way to make a macro run automatically after any cell in a spreadsheet is edited?

thanks

Posted by Ivan F Moala on June 13, 2001 7:57 AM

Look @ the Event procedures for this
since you are looking for a change in the spreadsheet then it is likely you will need
this @ the WorkBook level.
Something like;

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

MyRoutine 'Runs macro called MyRoutine

End Sub

HTH

Ivan

Posted by Kevin on June 14, 2001 9:33 AM

yes it did help - thanks Ivan