Is anyone having problem with Excel 2003 Application.ScreenUpdatin

[Guest]

Hi,
I'm having problem with Application.ScreenUpdating, I got a module
(DisableAppl) which only contain the following code:

With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableEvents = False
End With

When I type the following under Immediate Window, I get the following answer:
?application.ScreenUpdating=False
False
?Application.Calculation = xlCalculationManual
True
?Application.EnableEvents = False
True

The next thing I tried under Immediate Window is:

Application.ScreenUpdating=False

Then I typed again the following under Immediate Window is:
?application.ScreenUpdating=False
True

Which give me a true this time.

The DisableAppl module is the first action that get taken under another
module.

Could someone please let me know is there a work around?

 

[Guest]

Hi,

I just tried inserting
Debug.Print Application.ScreenUpdating
between sub-module in the main module, and in the Immediate Window I got
False, which is what I expect. however, when I typed:
?Application.ScreenUpdating
I got True, so which one is right?

Thanks

 

[Tom Ogilvy]

Screenupdating reverts to true when the macro ends. So both may be correct.