Disappearing Add-In

Excel_Phoenix

New Member
Joined
Mar 15, 2019
Messages
5
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.
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Excel_Phoenix

New Member
Joined
Mar 15, 2019
Messages
5
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,789
Messages
5,524,885
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top