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?
Suppress the movement on the sheet
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Suppress the movement on the sheet
Try adding
Application.ScreenUpdating = False
at the beginning, and
Application.ScreenUpdating = True
at the end.
Application.ScreenUpdating = False
at the beginning, and
Application.ScreenUpdating = True
at the end.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36
Re: Suppress the movement on the sheet
ok work now!HansV wrote:Try adding
Application.ScreenUpdating = False
at the beginning, and
Application.ScreenUpdating = True
at the end.
And to suppress "flipping/flikkering" of cursor?
Existis a method similar VB6....
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Suppress the movement on the sheet
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.
Application.Cursor = xlWait
at the beginning and
Application.Cursor = xlDefault
at the end, but you probably can't suppress the flickering entirely.
Best wishes,
Hans
Hans