MrExcel Publishing
Your One Stop for Excel Tips & Solutions

What's that screen update command?


Posted by Frank Krumm on December 26, 2001 11:11 AM

I have two worksheets in a workbook. From sheet 2 I run a formula on sheet1, then return back to sheet2 and update.

My code has ActivateSheet1 and ActivateSheet2 lines. Will disabling Screenupdate keep the screen from flashing back and forth from sheet1 to sheet2?


Posted by Cecil on December 26, 2001 11:13 AM

Yes it will. The command is
Application.Screenupdating = false

Posted by Jim on December 26, 2001 11:19 AM

and it doesn't seem to work in XP(home version)

Posted by Rick E. on December 26, 2001 11:19 AM

Be sure to turn "screen updating" back on after the macro runs with:

Application.Screenupdating = True

Posted by Frank Krumm on December 26, 2001 11:23 AM

Thanks guys! That's the ticket. EOM

Posted by Rick E on December 26, 2001 11:24 AM

Re: and it doesn't seem to work in XP(home version)

Your macro would look like:

Sub nameSomething()
Application.Screenupdating = False

' Then your code here
' in between the "Application.xxxxxx" lines
' and then

Application.Screenupdating = True
' Then the

End Sub

Posted by Jim on December 26, 2001 11:31 AM

Re: and it doesn't seem to work in XP(home version)

Hi Rick,

Thanks, i use it all the time, but what i meant was
it really "doesn't work in my XP version"

Happy Holidays

Jim