execute macro in another workbook, only works when interactive
I've got such a annoying problem and i no longer know what to do..
I've got two workbooks.
From the first one i make a call for a macro in the second workbook. What the macro in the second workbook does is only that it makes a printout of a sheet (in the same book)..
This works fine when i open the the second workbook and interactivitley start the printout macro, but nothin happens when calling macro from the other workbook.
I tested and the macro executes correctly but printout never happens, i also made an error handler and it gives no errors.
I noticed the same problem if i in the printout macro try to create and save a new excelfile...
So...
When calling macros in another workbook macros run correctly but printout and filecreation never seems to happen?
Much appreciate any help or suggestions
Best regards