Is anyone having problem with Excel 2003 Application.ScreenUpdatin
 

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?

Is anyone having problem with Excel 2003 Application.ScreenUpdatin
 

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


"augustus" wrote:

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?

Is anyone having problem with Excel 2003 Application.ScreenUpdatin
 

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

--
Regards,
Tom Ogilvy

"augustus" wrote in message
...
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


"augustus" wrote:

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?