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