Sheet level code fails when accessed via hyperlink

Hi Guys,

I am using a consolidation algorithm to pull in a bunch of info from a load of files. This works well for now. One of the things that it does is provide a hyperlink to each of the files it searches. This works. BUT, when I access one of those files, the sheet level code fails to run. The files to which I huperlink are supposed to open a second file as soon as they open - this does not happen. Sheets within the hyperlinked file are supposed to hide themselves as soon as they are de-activated - this does not happen. Basically, none of the code in the hyperlinked sheets will run on its own, as an event, as it is supposed to. I can force it to work by manually doing it as a macro.... but that is useless!

So any ideas as to what is happening differently when i open a file via hyperlink as opposed to opening it directly via explorer?

No ideas? I cannot find anything that helps with this. I presume it is an excel setting for security but I do cannot seem to get around it.