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