Managing Sheet Trigger Events
There is an Excel file that teaches how to perform the Managing Sheet Trigger Events operation.
Excel Source: Managing Sheet Trigger Events
This workbook captures sheet events using VBA triggers across a minimal three-sheet structure.
Hope it is useful.