VBA that's called by pivot table change. It calls about 4 macros that all impact the pivot table. I'm not sure where i should disable the events, in the change script or in the individual macros.
Any help is appreciated.
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Application.EnableEvents = False
Application.Visible = True
Application.ScreenUpdating = False

Call ForumlaInsert
MsgBox "hello"
Call SyncSlicers
MsgBox "hello Slicer"
Call Overhead
MsgBox "Overhead"
Call ActualCost
MsgBox "Act Cost"

Application.Visible = True
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub