execl sheets are blinking always

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
excel sheets are blinking always .please advice to rectify this
Click to expand...
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Budget Spreadsheet and Help Window is blinking 1
Blinking Button 2
How the content of a cell in excel blinking continusly ? 2
Hi Blinking/Flashing Text in cell based upon date value 1
Visual Basic "Blinking" Cursor??? 5
how can I show a flashing symbol in an Excel sheet? 2
Delete the contents of a cell if it contains #DIV/0! Automaticall. 4
Blinking text code error when sheet is protected 1

Back
Top