Workbook Deactivate Event

Syntax

Private Sub Workbook_Deactivate()

Enter Code

End Sub

This event will run every time a user selects a different workbook.