Suppress the movement on the sheet

[sal21]

I use a code to loop on the sheets in the workbook and make variuos operation, copy,paste, delete ecc...
But during this operation have the "flipping" effect...
I have used:
Application.DisplayAlerts = False
Application.EnableEvents = False
....code
Application.DisplayAlerts = true
Application.EnableEvents = true

but without success!!!

Exists other mode?

[HansV]

Try adding

Application.ScreenUpdating = False

at the beginning, and

Application.ScreenUpdating = True

at the end.

[sal21]

Try adding

Application.ScreenUpdating = False

at the beginning, and

Application.ScreenUpdating = True

at the end.

ok work now!
And to suppress "flipping/flikkering" of cursor?
Existis a method similar VB6....

[HansV]

You might try

Application.Cursor = xlWait

at the beginning and

Application.Cursor = xlDefault

at the end, but you probably can't suppress the flickering entirely.