473,320 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes and contribute your articles to a community of 473,320 developers and data experts.

VBA Project Signing

isladogs
455 Expert Mod 256MB
If anyone is interested, I’ve spent some time testing the new VBA Project Signing feature which is currently available to anyone running Office 365 on an Insiders channel (either Beta or Current Channel Preview). It will soon be released more widely to all those on the Current Channel.

The feature requires the developer to add a digital signature using a code signing certificate prior to distributing ACCDB/ACCDE apps.
This has always been possible in MDB/MDE files, but until now, not in ACCDB/ACCDE files

From my tests, it is certainly more complex to setup, at least initially but it will offer some advantages over using Trusted Locations or Trusted Documents:

1. Digitally signed files will run equally fast from untrusted locations. This is important for those users whose organisations prevent them running files from trusted locations and who, in recent months, may have experienced poor performance due to an anti-malware scan (AMSI) running EVERY time any code is run from an untrusted location

2. The digital signature is invalidated (and code can no longer run) if any changes are made to code or if action queries are modified. This provides additional security for the developer in that files cannot be modified in those respects after distribution

If you are interested in knowing more, see my web article and example app:
https://www.isladogs.co.uk/vba-project-signing/

I've also done a YouTube video to accompany this article
https://youtu.be/c5rnlcafBjM

Hope these are useful to others
Dec 13 '22 #1
1 10066
isladogs
455 Expert Mod 256MB
The VBA project signing feature was released to all 365 current channel users with the version 2212 update on Wed 4 Jan 2023.

I've updated my VBA Project Signing web page today and the YouTube video is available at https://www.youtube.com/watch?v=c5rnlcafBjM

For more details, see the MS Help article Show trust by adding a digital signature
Jan 5 '23 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Christian Schmitt | last post by:
Hi, after doing some more research, I found the following article describing how to get a free code signing certificate: http://www.dallaway.com/acad/webstart/ But I can't figure out how to...
3
by: Joel Leong | last post by:
I wish to know the industrial practices for signing assemblies with key files. I genereted a key file to sign my assemblies. Should I sign all my assemblies with a single key files or I shall...
1
by: Martin | last post by:
I have a couple of questions around code signing with MS technology: 1. Is there a way to transfer the generated strong name signing private key directly to a smartcard (or generate it on the...
1
by: Graham | last post by:
We use buildit to automatically build all of our solutions every night. In C# we are able to call a batch file for the post build event and sign the assembly for the GAC using our private/public...
1
by: | last post by:
Hello, I have the Microsoft Authenticode certificates (PKCS #7 Certificates, .spc and .pvk files) acquired from Verisign. How do I use this certificates to Sign the manifest for ClickOnce...
5
by: Richard J Foster | last post by:
Hi there, I have a pair of C# projects in VS2003. The first project, a dll, is referenced in the second via a project reference. The assemblies in question are delay-signed during a...
1
by: Jason Richmeier | last post by:
I have encountered an error while attempting to sign an assembly. I have become quite frustrated since I seem to be going in circles and making no progress. Hopefully someone will have the magic...
0
by: =?Utf-8?B?SWRhaG8gQmlsbA==?= | last post by:
Using VS2005 and Team Systems, I use Click Once to build and deploy my Windows Forms application from my desktop onto a network share. On the project's property page on the Signing tab, I check...
6
by: raylopez99 | last post by:
Anybody use Strong Name Signing? I think this is used by default for Resource files, which is one reason perhaps I can't get my resource files to work (somehow the public key is messed up, perhaps...
4
NeoPa
by: NeoPa | last post by:
Introduction: Macro Security Levels in MS Office applications are recommended to be set to High. This stops any VBA code associated with a project from running, unless it is signed (with a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.