was workbook opene by VBA or by a user directly

I need to put code in WB1 WorkbookOpen to determine if WB1 (ThisWorkbook) was opened via code in another workbook (WB2) or by a user directly.

There are too many existing WB2(s), that I don't have access to, in our company automatically opening the workbook I'm concerned about, so:
- I can't use a cell value or named range value that changes when it's opened by code, as I can't change the code in all the WB2s
- I can't disable events in WB2 before opening WB1 via code, as I can't change the code in all the WB2s
- I can't password protect WB1, as I can't change the code in all the WB2s

UserControl doesn't work because that's checking the Application not the workbook.

Hi carsto,

Difficult situation, especially since you can't control the father workbooks.

In your situation, I don't know how to determine if the workbook was opened by VBA.

However, you can determine if it was opened not by VBA. Sub Auto_Open() will run after Workbook_Open(). It will not run if workbook is opened programmatically (i.e. by VBA).

Put Auto_Open() in an ordinary code module such as Module1:

Sub Auto_Open()
  MsgBox "Auto_Open(): Workbook was NOT opened by VBA."
End Sub

I hope this helps.

Lewis