execl sheets are blinking always

F

Frank Kabel

Hi
what do you mean with 'blinking'. Does this happen at a specific
situation?

--
Regards
Frank Kabel
Frankfurt, Germany

MH said:
excel sheets are blinking always .please advice to rectify this
Click to expand...
problem
 
K

Ken Wright

Assume you are running code and the sheets are flashing as you do so, in which
case try

Application.ScreenUpdating = False

at the start of your code
 
D

David McRitchie

Turning off Screen updating should fix the blinking but the
underlying cause is probably changing the active cell
and/or active worksheet while running a macro, which
is bad coding.
http://www.mvps.org/dmcritchie/excel/slowresp.htm

Turning off calculation during the running of a macro
will speed up the macro considerably.

If you are not using macro or user defined functions, you
probably have some serious problem such as misuse of
SUM Worksheet Function (overlapping SUMs) causing
lots and lots of recalculations.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Top