Annoying VBA popup – how to avoid the ActiveX Control Warning
When I, and others, open my Excel VBA toolbox of macros – a message saying ” <<details to come>> you are about to open an ActiveX control. Are you sure … or something” appears. Here is the solution – you need to sign the macro with a certificate. Really this inflates people’s heads because we are doing something advanced – but really – it just annoys me as it is just a lot of extra work for me. I hope this helps others.