Worksheet Activate() Event

Syntax

Private Sub Worksheet_Activate()

Enter Code

End Sub

This event occurs when a workbook, worksheet, chart sheet, or embedded chart is activated.