Two Workbooks

[Donald Lloyd]

Hi,

Book1 has code that opens Book2.
The WorkBook.Open events in Book2 don't run.

Is there a solution or an alternative way to run the code in Book2 ?


regards,
Don

--

 

[Tom Ogilvy]

Unless events are disabled, the workbook_open event in book2 should run
(unless you open up the workbook using a macro started with a shortcut key
combination which includes a Shift). If your macro in book2 is actually an
Autpen macro, then these do not run when the workbook is opened
programmatically. You would have to start it with your code.

 

[Donald Lloyd]

Hi,

Thanks to your combined superior expertise I've managed to sort it out - I
think!

I really don't know of any other way there is to get get specific advice on
what are often obscure problems.

regards,
Don