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!