Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Updating
I'm using Excel 2003. I start out each prodedure with the following
two lines of code: Application.EnableEvents=False Application.ScreenUpdating=False From the beginning of time until now, these two lines of code worked as desired. Now, however, the value for Application.ScreenUpdating remains True. I've trapped the code to move through each line of code. The line of code is read, but the value remains True. Application.EnableEvents works as expected. The value changes to False. Has anyone been encountering this issue? Thanks. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Updating
|I've trapped the code to move through each line of code.
that maybe problem. when you do debugging screenupdating always true (so you can see what happen i think). when you run code at full speed it screen shoud be turned of by the code. wrote in message ... | I'm using Excel 2003. I start out each prodedure with the following | two lines of code: | | Application.EnableEvents=False | Application.ScreenUpdating=False | | From the beginning of time until now, these two lines of code worked | as desired. Now, however, the value for Application.ScreenUpdating | remains True. I've trapped the code to move through each line of code. | The line of code is read, but the value remains True. | | Application.EnableEvents works as expected. The value changes to | False. | | Has anyone been encountering this issue? | | Thanks. | | Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Updating
Are you sure that the setting isn't changing to true some place in your code.
There are some things (calling functions in the analysis toolpak, IIRC) that change this setting. I'd pepper the code with statements like: Debug.print "Step 1: " & Application.ScreenUpdating some code Debug.print "Step 2: " & Application.ScreenUpdating more code Debug.print "Step 3: " & Application.ScreenUpdating .... To see where it's getting changed. If it is something that you can't control. Then you may just want to find that spot and turn off .screenupdating after it's toggled back on. " wrote: I'm using Excel 2003. I start out each prodedure with the following two lines of code: Application.EnableEvents=False Application.ScreenUpdating=False From the beginning of time until now, these two lines of code worked as desired. Now, however, the value for Application.ScreenUpdating remains True. I've trapped the code to move through each line of code. The line of code is read, but the value remains True. Application.EnableEvents works as expected. The value changes to False. Has anyone been encountering this issue? Thanks. Michael -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Updating
Ps. If you close excel, reboot the pc and start again, do you have the same
trouble? (If that setting always stays on???) " wrote: I'm using Excel 2003. I start out each prodedure with the following two lines of code: Application.EnableEvents=False Application.ScreenUpdating=False From the beginning of time until now, these two lines of code worked as desired. Now, however, the value for Application.ScreenUpdating remains True. I've trapped the code to move through each line of code. The line of code is read, but the value remains True. Application.EnableEvents works as expected. The value changes to False. Has anyone been encountering this issue? Thanks. Michael -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Updating
On Oct 19, 10:58*am, Dave Peterson wrote:
Ps. *If you close excel, reboot the pc and start again, do you have the same trouble? (If that setting always stays on???) " wrote: I'm using Excel 2003. I start out each prodedure with the following two lines of code: Application.EnableEvents=False Application.ScreenUpdating=False From the beginning of time until now, these two lines of code worked as desired. Now, however, the value for Application.ScreenUpdating remains True. I've trapped the code to move through each line of code. The line of code is read, but the value remains True. Application.EnableEvents works as expected. The value changes to False. Has anyone been encountering this issue? Thanks. Michael -- Dave Peterson- Hide quoted text - - Show quoted text - Thanks for your insights, Dave. Yes, I re-booted earlier. But the issue persisted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen flicker w/ Screen-Updating = False? | Excel Programming | |||
Screen Updating | Excel Programming | |||
Screen Updating | Excel Programming | |||
Screen Updating | Excel Programming | |||
Screen Updating | Excel Programming |