| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - the "X" to exit the application option is greyed out. | Excel Discussion (Misc queries) | |||
| Excel 2003 and Application.Quit | Excel Programming | |||
| Problem quitting excel when it is used by ASP.NET application | Excel Programming | |||
| Problem on the ASP using the Excel.Application Object | Excel Programming | |||
| Problem with closing the excel application | Excel Programming | |||
Linear Mode
