when i try to run the following code:
It shows the Master Log sheet. When I trace this program and stop on the second line applicaton.screenupdating still equals TRUE. Please helpApplication.ScreenUpdating = False Application.GoTo Reference:=Worksheets("Master Log").Range("A1")
Last edited by Aussiebear; 03-29-2023 at 06:17 PM. Reason: Adjusted the code tags
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
Okay, then try this
[vba]
Application.ScreenUpdating = False
Debug.Print Application.ScreenUpdating
Application.Goto Reference:=Worksheets("Master Log").Range("A1")
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Debug shows it as False.
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
Exactly! So what do you deduce from that?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
That something is overriding the value (or superceding it)
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
Well yes in a way.
If you turn off ScreenUpdating, contrary to what Help says, when the procedure completes, it is back on again. That is, when Excel takes back control, Screenupdating is automatically turned on.
So my reading is that if you interrupt code to do something that involves the screen then Excel takes over and Screenupdating is restored
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Yes but when I step through the program, hover the cursor over application.screenupdating is shows TRUE immediately after the line
application.screenupdating = FALSE
Last edited by Aussiebear; 03-29-2023 at 06:18 PM. Reason: Adjusted the code tags
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
Because steepping through and hovering causes screen interaction, hence it needs to make updating available to show you the values. That was exactly the point I was driving at.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
so your saying that breaking the program caused screenupdating to revert back to TRUE?
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
Posting Permissions
Reply With Quote
