Please Help with ScreenUpdating..... This is driving me nuts
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.
"Susan Lammi" wrote in message
...
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
"Susan Lammi" wrote in message
...
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
|