Workbook Activate Event

Syntax
Private Sub Workbook_Activate()
Enter Code Here
End Sub

This event will run code whenever this specific workbook is activated.
Example
Private Sub Workbook_Activate()
Login.Show
End Sub

This example will load a UserForm named "Login." For this example to work you will already need a UserForm created with the name "Login"