Application.ScreenUpdating = False

[LB79]

Im having a problem with screen updating. I have 7 workbooks that hav
the same macros - all have Application.ScreenUpdating = False as th
first line. This is working in 4 workbooks but for some reason its no
in the other 3. The macros are identical. Does anyone know of a proble
that could cause this?

Thank

 

[Dave Peterson]

There are some things that cause screenupdating to get changed to true.

Maybe that one workbook is branching to a portion of the code that the other
workbooks don't execute.

You may want to pepper your code with lines like:

debug.print "SC#1--" & application.screenupdating

(and increment that number)

Then look at the immediate window and see if you can find where it returns
true. Then add an:

application.screenupdating = false

right after that portion of the code.