Application.EnableAnimations Property (Excel)
True if animated insertion and deletion is enabled. Read/write Boolean.
A variable that represents an Application object.
When animation is enabled, inserted worksheet rows and columns appear slowly, and deleted worksheet rows and columns disappear slowly.
This example turns off animated insertion and deletion.
Application.EnableAnimations = False