- Dec 5, 2002
- Office Version
Hi KeepTrying,Dear Jaafar,
Thanks a lot for dropping by I wouldn't have thought this determination can be so complex.
Workbooks - which are opened by userform - are not always the same but if you can create a solution for fixed workbooks I'd be really grateful.
I took a look at the WH_CALLWNDPROC hook approach , unfortunately it only works with Top-level windows ... Workbook windows are child windows so it won't work to trap the opening of workbooks.
I am assuming that the userform that is running is Modeless - Can you confirm that ?