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?