How to stop running "ThisWorkbook" codes when opening Excel file by macro

Hi everybody,

I'd like to ask you for help in this particular case:

- I have got an Excel file, that runs a macro that opens another workbook and copies over the data from this workbook

- the problem is that the other workbook runs a macro (launch userform) whenever it's opened, which is annoying for the user.

Do you have any idea, if one can actually somehow turn off "ThisWorkbook" codes?

Please Login or Register  to view this content.

Thank you for any suggestion!

Thank you! Works great!