VBA Tip: Disable Events


If you need to execute a part of code without triggering any event, place the code between these two lines:

CopySub example()

    Application.EnableEvents = False ' => disable events
    
    'The code ...
    
    Application.EnableEvents = True ' => enable events
    
End Sub