Disappearing Add-In

[Excel_Phoenix]

Hi all,

I've created an add-in that is deployed on a network (I keep a local copy for making amendments before uploading to the network). The add-in works fine for most users but for some it disappears (remains in the add-in menu but is unticked and the custom menu disappears) once Excel is closed. It seems to just be those using Excel 2016.

Any suggestions for making it 'stick'? (internet research suggests it may be a security issue)

Thanks.

 

[Excel_Phoenix]

Anyone?

 

[Excel_Phoenix]

Quick update, just in case anybody else has the same issue ... Solved (hope that isn't tempting fate!)

My custom menu was added with Workbook_AddinInstall and removed with Workbook_AddinUninstall. I've now extended this to also include Workbook_Open and Workbook_BeforeClose. I can't see why this is necessary but, for now at least, it seems to be working