How to enable macros when a file is opened from another macro

Hi,
This SUB in excel 2007 must open a file containing macros (so it's an .xlsm file).

The file is opened, but oftenly macros are not automatically enabled. Sometimes excel shows the traditional Warning message asking if I'd like to enable macros, but many times it doesn't. So in those cases I need to go to the opened file and click the Options button to manually enable macros. This is against the automatization process I'm trying to implement, as the amount of files I need to open is high.

Could anybody suggest how to always automatically enable macros of the file to be opened?

Please Login or Register  to view this content.

Macros should be automatically enabled if you open a workbook in code unless you have explicitly changed the application.automationsecurity property in your code and forgotten to reset it.