execl sheets are blinking always
 

excel sheets are blinking always .please advice to rectify this problem

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

--
Regards
Frank Kabel
Frankfurt, Germany

"MH" schrieb im Newsbeitrag
...
excel sheets are blinking always .please advice to rectify this
problem

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"MH" wrote in message
...
excel sheets are blinking always .please advice to rectify this problem


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.804 / Virus Database: 546 - Release Date: 30/11/2004

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