EnableAnimations Property
Applies To
Application object.
Description
True if animated insertion and deletion is enabled. Read/write Boolean.
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