search

sdllc / Basic-Excel-R-Toolkit

http://bert-toolkit.com
207 stars 40 forks source link

After ending BERT add in is set to inactive (not disabled) #86

Open laermbote opened 7 years ago

laermbote commented 7 years ago

Great tool, but I have always to activate the addin manually. When I Close Excel it is disabled. It worked well, since yesterday I have this Problem. It is Excel 2013 32b Thanks Karsten

duncanwerner commented 6 years ago

When you say it's disabled, do you mean specifically it is in the "disabled add-ins" category, or is it in the "inactive add-ins" category? Also, if you go to add-ins -> COM add-ins and select the BERT add-in, what does it say after "Load Behavior"?

laermbote commented 6 years ago

sorry to be unprecise (it a german Laptop) and thanks for your answer. It is not deactivated but the check box in COM Add-ins is always unmarked. I solved this with a autorun vba script but maybe there is an easier way. And after marking the Checkbox works fine. no message at all.

duncanwerner commented 6 years ago

When I select it in the add-ins dialog, it says "load at startup". I'm not sure what the german windows equivalent is, but it should be something like that. If it says something like "load manually", that is the problem.

untitled-1

If that is the case, the problem is a registry setting. Re-installing may take care of it. If you are comfortable editing the registry, I can explain how to reset this, but there is no way to do it from within Excel.

laermbote commented 6 years ago

Ok, I got it. It says "Loaded" , other Elements are shown as "Load at Startup". Do you know where to Change it? thanks Karsten

duncanwerner commented 6 years ago

You can only change this in the registry, but re-installing should set it. If you are comfortable with the registry, the key is 

Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\BERTRibbon.Connect

In that key, set LoadBehavior to 3. It is probably set to 1 or 2.

(Edit) make sure that Excel is closed before you change that, or it may reset it.

laermbote commented 6 years ago

thanks a lot. I looked into the registry before but discovered only the versions (14., 15.) and overlooked the generic Excel entries. Changed it and it works. Thanks again. It is a phantastic tool, I don't want to miss it anymore.