[EXCEL] Suppress Compile error in hidden module

I am getting an error when I am programmatically opening another Workbook from my macro:
Compile error in hidden module: ThisWorkbook

Code:

---

Set wb = Workbooks.Open(Filename:=strFileName, UpdateLinks:=False, ReadOnly:=True)

---

Essentially this is because the workbook I am opening contains unresolved references.

However, I am not in a position to get hold of these references.
I don't actually need them though as I am only interested in the current data on the sheets that I am using as inputs to my process.

Is there anyway to suppress this error so that the user doesn't have to click on it?
I tried

Code:

---

Application.DisplayAlerts = False

---

and

Code:

---

On Error Resume Next

---

with no luck.

Is it possible to specify that macros will be disabled when opening a workbook?

Quote:

---

Is it possible to specify that macros will be disabled when opening a workbook?

---

Via code... No

But if the users are going to open the file in your computer then, you can always set the security level to medium manually....