Hide Excel VBA process while running 2

[cariengon]

I'm sure someone has asked this, but I'm not sure about the wording...

Is there code to make it so the VBA code that is being run is done in the background? I have a "Setup" page that the user uses to click buttons to import/sort data in other sheets. I don't want the user to see all of the activity...

Thanks!
Carie

 

[DaleWatson123321]

At the start use: Application.ScreenUpdating = False

At the end use: Application.ScreenUpdating = True

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[cariengon]

Thank you Dale!!!

I've used it before but couldn't remember the syntax!

Much Appreciated -
Carie