SheetChange Event - Gary Bailey

Posted by JohnG on January 31, 2002 5:47 AM

As far as I am aware

Private Sub Appl_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range)

Is for only sheets in the workbook its in where as

Private Sub Appl_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range)

is for any worksheet.

Posted by Ivan F Moala on January 31, 2002 10:04 AM

Gary is correct.....you are right in your thinking
but not for the class event.

Ivan