I find that Workbook.Activate doesn't always bring that workbook to the front of the window. I wonder what is the right way to set a workbook as the top of the window so when the macro is finished this is the workbook you are looking at.
Should I use any Windows() based code or is this related to .setfocus? I am just guessing.