model in excel: auto_open and in thisworkbook workbook_open

S

SteAXA

Someone can explain to me why when i open (right click / open) an excel model
it's execute statements in this order:
1. workbook_open (in thisworkbook)
2. workbook_activate (in thisworkbook)
3. AUTO_OPEN (in a module)
but when i use new on a model (right click / new), excel execute statements
in this order:
1. AUTO_OPEN (in a module)
2. workbook_open (in thisworkbook)
3. workbook_activate (in thisworkbook)
Thanks for each explanation, regards.
 

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

Top