How to ignore auto_open() when Workbooks.Open

[Ceeyee]

Hi,

When I open another workbook in VBA through Workbooks.Open, how to let the program NOT run the auto_open() in that workbook?

Thanks.

 

[Juan Pablo González]

Actually, the Autpen doesn't run automatically when you open a workbook through VBA. Only the Workbook_Open() event fires.

If that's what you are using, then put

Application.EnableEvents = False

before opening the file, and restore it to True afterwards.

 

[Ceeyee]

Thanks Juan.