Macros set to run upon opening, arent running when workbook is opended by 'helper'workbook

[morangeman]

Hello,
I am using the below code to open another workbook in Calculation Manual mode which is working fine, however when that workbook is opened, the macros set to autorun upon opening aren't running.....
Any idea on the piece of code I need to add in to make these run? I have tried various uses of Application.Run but i get an error saying macro blah blah cannot be found or may be disabled..... Im at a loss....

Helper workbook code:

Please Login or Register  to view this content.

Any Ideas?

[rorya]

Your target workbook is an xlsx file, which cannot contain macros.

[morangeman]

Your target workbook is an xlsx file, which cannot contain macros.

That's just a sample file name. In the actual helper file module it's labeled as workbookname.xlsm etc.

[rorya]

What is the code in the target workbook that should run automatically?

[morangeman]

What is the code in the target workbook that should run automatically?

The workbook is set to call the sub 'Load' when opened. If I open this workbook directly, it runs the sub fine, but if I open it from this other workbook, the sub doesn't run when opened.

Please Login or Register  to view this content.

[rorya]

The workbook is set to call the sub 'Load' when opened.

How?

If it’s an auto_open routine, it has to be called explicitly by your code. If it’s Workbook_open, it will run unless you disabled events, or automation security is set to disable.

[morangeman]

How?

If it’s an auto_open routine, it has to be called explicitly by your code. If it’s Workbook_open, it will run unless you disabled events, or automation security is set to disable.

Events aren't disabled, there are no security options causing an issue. If i open the file directly it simply runs and does what it does. If i open the file from another workbook it opens but the macros don't run, even if it is setup to run automatically when opened. Both files are trusted documents so I'm at a loss......

[rorya]

Have you actually checked the value of application.automationsecurity to be sure?

It’s generally not a great idea to close a workbook from its Open event so I’d suggest you use application.ontime in the first Open event to run the actual code.