EnableAnimations Property

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