Excel Add-in unchecks sometimes - Create VBA with a command button to check it

[nickthebizz]

Hi,

So I have a slight issue with one of my Add-ins.
Sometimes when i open excel the Astmlib add in just unload and my formulas do not work. So i need to go to options addin and check it again.

Searching in this forum and on the internet I have understood that this might be an issue if the add-in was made from an earlier version of excel and there are solutions to overcome this. But becuase I am no expert i beeive i might not manage to make the correction.

So a solution for me would be to create a VBA code that I could tricker with a button somewhere in my main sheet to run the add in.

Is this possible?

thanks

 

[Marcelo Branco]

See if this helps - it refers to a different Add-In but maybe you're facing a similar issue.

XL2BB Disappears when Excel is Reopened

If this happens to you, try one of these options: Option A: Close Excel Find the Add-In file in Windows File Explorer Right click - Properties On the 'General' tab, is there an 'Unblock' box at the bottom? If so, tick that box then click OK Reopen Excel Option B: An alternative to the above...

www.mrexcel.com

M.

 

[nickthebizz]

Thank you

the options provided from the post do not apply in my case. option A I have no unblock box and the file is in a trusted location.

Is there a way I could make a button to run an VBA code whereever it is unchecked to run it?

Nikolas

 

[Marcelo Branco]

Nikolas

I don't know how to make such a button in VBA ...

Are you sure there is no Unblock button when you right click and choose Properties? There should be ...
Just to test it again - Copy /Paste the .xlam file to another folder, right click; Properties; and make sure there is no Unblock.

M.

 

[nickthebizz]

 

[Marcelo Branco]

I dont know how to help you. I will do more research, but in the meantime I hope someone else can help you.

One question: did you create the add-in yourself or downloaded it from somewhere?

M.

 

[nickthebizz]

I dont know how to help you. I will do more research, but in the meantime I hope someone else can help you.

One question: did you create the add-in yourself or downloaded it from somewhere?

M.

a friend created it long time ago

 

[nickthebizz]

thank you

 

[Fluff]

Try

Sub EnableAddin()
    AddIns("Astmlib").Installed = True
End Sub

 

[nickthebizz]

Works great!

thank you