[RESOLVED] Hiding "working" macro

When the macro executes, is there a way to hide what the macro is doing so that the user does not see everything that happens in the background. Also, is there a way to open a workbook from a macro and pull information out of it without it being "open" for the user to see?

Any help is appreciated.
Thanks!

try at the start of your code

vb Code:

application.sceenupdaing = false

set to true at end of code

vb Code:

Application.ScreenUpdating = False

Thanks, it works perfectly!