Turn screen update off; then back on during macro

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I'm new to Excel VBA and struggling with syntax.

I have a macro tied to a form command button. I'd like to:

1. Turn the Excel screen update(s) off;
2. Run the code on the button;
3. Turn the Excell screen updates back on.

Is there a method/class/whatever to do this? The macro adds data to a
couple of worksheets; I'd like the macro to run without showing the user
what's going on.

Thanks! in advance.

--Dan
 
Hi Dan
Put this at the beginning of your macro:
Application.ScreenUpdating = False
This one before End Sub
Application.ScreenUpdating = True
HTH
John
 
:) Thanks!

John said:
Hi Dan
Put this at the beginning of your macro:
Application.ScreenUpdating = False
This one before End Sub
Application.ScreenUpdating = True
HTH
John


.
Click to expand...
 
Back
Top