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
"Gerald Evans" wrote
Just another guess but do you have AutoSave enabled?
"Ken Wright" ...
Assume you are running code and the sheets are flashing as you
do so, in which case try
Application.ScreenUpdating = False
"MH" wrote ...
excel sheets are blinking always .please advice to rectify this problem