[EXCEL] Suppress Compile error in hidden module

[agmorgan]

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

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

Application.DisplayAlerts = False

and

On Error Resume Next

with no luck.

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

[Siddharth Rout]

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....