Turn screen update off; then back on during macro

[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

 

[John]

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

 

[Dan]

Thanks!

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


.

 

[John]

You're welcome Dan
I'm new to VBA myself, but knew your answer.
Regards
John