Two Workbooks

  • Thread starter Thread starter Donald Lloyd
  • Start date Start date
D

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

--
 
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
Auto_Open macro, then these do not run when the workbook is opened
programmatically. You would have to start it with your code.
 
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
 
Back
Top