ThisWorkbookPrivate Sub Workbook_SheetActivate(ByVal Sh As Object) If Sh.Name = "My Sheet" Then shwMsg End SubPrivate Sub Workbook_SheetDeactivate(ByVal Sh As Object) If Sh.Name = "My Sheet" Then 'Cancel Application OnTime end if End Sub
ThisWorkbookPrivate Sub Workbook_SheetActivate(ByVal Sh As Object) If Sh.Name = "My Sheet" Then shwMsg End SubPrivate Sub Workbook_SheetDeactivate(ByVal Sh As Object) If Sh.Name = "My Sheet" Then 'Cancel Application OnTime end if End Sub
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ