Posts Tagged ‘ Certificate ’

Share Digital Certificate for VBA Between Several PC(s)

2017/10/18
By
Modified: 2017/09/16
Excel-Install-Certificate

This article is about time saving, when it comes to enable your macros in Excel every time you open the file. You do not want to allow all macro to run.  But if you don’t, you have to constantly enable your macros over and over again, when you open your Excel files.  To eliminate this, you can create a self-signed digital certificate and this work fine on one PC. But what, if you need to open the same files with macros from several PC(s) on your network.  I think I found a solution on how to create a certificate on one PC and then install that certificate on other PC(s). This…

Read more »


You can sign PowerShell certificates with New-SelfSignedCertificate and without MakeCert

2017/10/06
By
Modified: 2017/09/16
_20 Code Signing Certificate

  For those who can’t wait, here is the solution right away. Next two lines actually work – without using MakeCert.exe: New-SelfSignedCertificate -DnsName STA07 -Type CodeSigning Set-AuthenticodeSignature C:\T\add-signature.ps1 @(gci Cert:\LocalMachine\My -DnsName STA07 -codesigning)[0] First command creates a certificate in your Intermediate Certification Authorities.  Second command signs the script.  Wow!  Innocent error in documentation from our Seattle friends (https://technet.microsoft.com/en-us/library/hh847874.aspx) probably due to luck of testing.  But a very satisfying result in the end. Now the whole story. On Monday, 2016-02-22 I converted last PC to Windows 10.  A got a nice clean and crispy install.  Everything is working well.  Everything is in place.  I do not want to install any ad hoc software…

Read more »