unable to control screenupdating

  • Thread starter Thread starter Susan Lammi
  • Start date Start date
S

Susan Lammi

I have some very extensive VBA Code running in Excel. I am having trouble
controling the screen updating.

It seems that anytime I open a new workbook via VBA the screenupdating
resets to True also

Running in debug I can see that sometimes the command
Application.screenupdating=false seems not to have any effect at all.

Are there any hints/tips anyone can offer.

Thanks
 
I am continuing to have this problem.....

Further testing has revealed really odd behavior....
Setting a break just prior to the command
"Application.ScreenUpdating=False"
Set thru the command and ScreenUpdating is still True

Go to the Immediate window and enter the command manually and the command
has the
desired effect... ScreenUpdating=False

What's Up... This is driving me NUTSSSSSS
 
Hi Susan:

Please post your code.

Once a macro finishes running, ScreenUpdating will automatically be reset to
True.

Regards,

Vasant.
 
First, when you are activating another workbook that one has now become the
active workbook therefore ScreenUpdating will be set back to true. If you
are opening the same workbook each time then just set screenupdating to
false in that workbooks open event.
 
Back
Top