Hello masters,

I am using Application.Run in my workbook to call a macro from another workbook.
I read documents stating I have to use Application.Run "file.xlsm!macro"
It is working like a charm, but here is my questions:

1- This will open the file and execute the macro. It seems "ScreenUpdating = Off" does not work
Is there any other alternative?


This will open the file and "needs to close the file when done", such as workbooks.close.

So ScreenUpdating = Off would make the whole experience a lot cleaner, no more pop up programs (open/close) of screen flickering.

Please advise.

Thank you!