unable to control screenupdating
 

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

Please Help with ScreenUpdating..... This is driving me nuts
 

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

Please Help with ScreenUpdating..... This is driving me nuts
 

Hi Susan:

Please post your code.

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

Regards,

Vasant.

"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

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