XLA add-in Abort load on Auto_Open

G

Guest

Is there a way to Abort load of an XLA add-in in its Auto_Open or similar
subroutine.

XLA will contain version information. If user is not using the latest
version determined by a function, I want the load/AddinInstall Aborted.
Currently, I use Auto_Open subroutine to call my version check function, but
do not see a way to Abort the Auto_Open or load of the add-in.
 
J

Jim Rech

I think you can abort the load simply by having the workbook/add-in close
itself:

ThisWorkbook.Close False

--
Jim
| Is there a way to Abort load of an XLA add-in in its Auto_Open or similar
| subroutine.
|
| XLA will contain version information. If user is not using the latest
| version determined by a function, I want the load/AddinInstall Aborted.
| Currently, I use Auto_Open subroutine to call my version check function,
but
| do not see a way to Abort the Auto_Open or load of the add-in.
 

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

hide/protext auto_open code so user can't prevent it from running 4
Auto_Open & Add in 2
UDF shows #NAME? when moved from XLA to XLL 2
Avoid unloading of .xla addins when closing books are cancelled. 4
How to launch one XLA from another on Excel launch 1
Addin Auto_Open code executes only in debug mode 2
excel 2003 Reading workbook properties / details from an XLA how do you do it? 1
Handling a worksheet calculate event in XLA code 4

Top