In the hope of improving responses on this thread, I am uploading a test workbook. It is very much an experimental work in progress so please keep that in mind when viewing the code.
I'll probably regret uploading this as a quick skim of the code will probably turn off 99% of programmers. I apologise that the code isn't easy to follow. It's currently very tangled as I am striving to consolidate multiple workbook Open/Save concepts into one integrated whole. (e.g. install add-in by double clicking, force users to enable macros, Version updater etcetcera - for more detail see the comments in the module "tx_TWB_events_150204" ) (My goal is that once these are all successfully integrated, each one can be turned on/off to suit your projects needs)
To test the workbook:
- Alter the tool requirements (module = "usr_ThisTool_Reqs_150203") so that at least one of them doesn't meet your set-up/environment. (Personally I've been turning the "mblncREQUIRES_EXCEL_VBP_ACCESS" to True)
- Save the XLSM as an XLAM
- Close the XLSM. Close Excel
- Now try to install the XLAM. Test any (or all) methods of installing e.g. 1) double click on the XLAM 2) Copy the XLAM to your UserLibraryPath before opening Excel then try ticking in the Add-Ins manager 3) Use the Add-Ins Manager to browse to the XLAM
I can get the XLSM to close if conditions are not met but I fail to untick the XLAM if conditions are not met.
Bookmarks