I sometimes get annoyed that i have to manually update Pivot tables and the likes, therefore i hope these can help other people as well. If there is any i have forgotten please comment, i’m still a bit new in the VBA world.

 

Private sub Worksheet_Deactivate() ‘ what to do when you leave a worksheet

Private Sub Worksheet_SelectionChange(ByVal Target As Range) ‘ Change or do when changes occur in area

Private Sub Worksheet_Change(ByVal Target As Range) ‘ Change or do when changes occur in worksheet

Private sub Worksheet_Activate() ‘ what to do when a sheet opens/ is selected