Macros disabled when opening workbook using VBA

[edyork]

Hi,

I'm having an issue with Excel 2013 disabling Macros without notification when opening a workbook using VBA in another workbook.

I've tried all of the obvious security setting combinations but I can't even get a notification to ask if I want to disable macros, they are just automatically disabled.

The workbook functions fine when opening from Windows Explorer etc.

Any ideas?

Thanks for your help in advance