View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default Turn screen update off; then back on during macro

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