Preventing Excel From Showing What A Macro is Doing As it Runs

[cicconmr]

Hey All,

Not sure how to word this, so if there has been another thread on it I apologize. I'm assuming I'm not the only one to have this problem but in developing Macros for other users I've noticed that when a Macro runs it tends to show the user what is going on.

I.e. I may have an interface sheet which is the only sheet I wish a user to see, however, that information on that home sheet may be derived from other hidden sheets. So as my macro runs that populates a list or sorts a column for the user, Excel flips to the sheet where the Macro is being ran.

It looks sloppy and defeats the purporse of having all my data hidden from the user. How can I make it so that while the Macro runs Excel only views the sheet that I want to user to see?

I hope this made some sense....

Disclaimer: I have made sure that no where in my code does it say Workbook().Range.Select, etc. for the regions I don't want to be viewed.

 

[sous2817]

Hello and welcome to the board!

At the start of your macro put:

Application.ScreenUpdating = False

and at the end put:

Application.ScreenUpdating = True