Hi. Trying to find out if the following is possible with VBA: I am in one Excel workbook ("MasterFile.xlsm") and I want to attach vba code to a button that will open another workbook ("Region.xlsm"), print a worksheet in the "Region.xlsm" file, Save and Close that file. I have been able to accomplish this but, I don't want the "Region" file to be visible on screen while this it is running. In other words, can it do all of this in the background of the "MasterFile" or can it be minimized? I am currently using the following code:
This works but since the "Region" file is large, it takes time to open and starts displaying partial data on the "MasterFile" while it is working. I'd rather it take it's time to open and close without the user knowing what is going on. Perhaps a Message box could appear saying that the report is generating and not to touch any keys. Thanks.
Bookmarks