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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling open workbook from another workbook 8
Copying formulas to other workbooks 5
Setting name value across workbooks 5
minimize just opened workbook window 1
Macro needed 3
Change workbook name to a generic name 4
Automatically Excuting a Macro in a different workbook ? 10
xlfTextRef from another workbook 1

Back
Top