I am doing a concert where I need to write some simple VBA macros for Word and Excel. This is a skill that I have not used in about 8 years - and everything has changed! In addition to the small details that VBA is clearly in legacy mode, with minimal support, all new security measures are designed to close VBA as a malicious vector.
Most of them can be done with little effort. But here's a biggie: on some machines (not for various reasons), IT professionals have disabled VBA's ability to link to external libraries. If you give the user a VBA application that uses the MS scripting runtime (a convenient regular expression API) or an automation library for another application (to control Word from Excel), they just don't work. If you open the VBA IDE on a user machine, the tools / links will be grayed out.
I could work with IT professionals to re-enable bibliographic references, but there are external users who may have this limitation. So I need a way around it.
If I buy a certificate and sign macros, will it give me links? I can make them spend money, but I am not going to do it if I am not convinced that this will solve the problem.
source share