Hi,
Organisations are getting more and more jittery about allowing the use of Excel files that contain VBA code. Does anyone have any advice on the best way to ensure that my files with VBA are accepted by a company and allow users to execute the code?
I know you can specify trusted locations and trusted publishers. If you want to be a trusted publisher do you need to obtain a digital certificate. If you do how do you go about this and is there a cost in doing so. I saw something about creating your own digital certificate is this possible?
Thanks for any help.
Bax
Certificates will expire. When they do, most likely you will have to release a new version of your app signed with a renewed certificate, otherwise users will not be able to use the old version without changing the macro settings to allow any macro, even if digital signature is invalid.
You can also convert the excel file to .exe application. They will no longer require user permission to allow macros to run, but there are downsides: will not work on Mac anymore and antivirus software will isolate the .exe app most probably, if it's not... signed.
You can also try the excel solution posted here: https://www.excel-first.com/hide-excel-sheets-if-macros-are-not-enabled/
Hide sheets until they allow macros to run, only then they will be able to use the app.
