Determining how a workbook was opened

[Oseitutuakrasi]

Dear Friends,

Is it possible to write a VBA code that will tell me how a workbook was opened (i.e. from Windows Explorer or from another workbook)?
For example, I can open WorkbookA from the Windows Explorer. If I have WorkbookB, I can also open WorkbookA from within WorkbookB
Is there a way to determine which method I used.

Thank you All

 

[Micron]

I would venture to say no, not possible. In Access it is possible to know if users don't use a shortcut on their desktop but that would only tell you if they didn't use the prescribed shortcut. I tested and it seems that the Excel guys didn't attend that vba meeting , so even that seems to be unavailable in Excel.

 

[Oseitutuakrasi]

I would venture to say no, not possible. In Access it is possible to know if users don't use a shortcut on their desktop but that would only tell you if they didn't use the prescribed shortcut. I tested and it seems that the Excel guys didn't attend that vba meeting , so even that seems to be unavailable in Excel.

Thank you Micron. Wouldn't waste my time then.

Regards.