EnableAnimations Property [Excel 2003 VBA Language Reference]
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
Applies to | Application Object