New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

FREE Code Certification Tool (SELFCERT)

Free Excel Tips and Tutorials

FREE Code Certification Tool (SELFCERT)

Postby Sisyphus » Tue Feb 28, 2012 9:34 pm

Are you tired of seeing Excel's 'Security Warning' and clicking 'Enable Macros' every time you open your own macro-enabled files?
If your code has a certificate attached you won't see it any more. You can get such a certificate free of charge, or at a small price if you wish to subscribe to support and guarantee.
http://www.abylonsoft.com/selfcert/download.htm

After downloading the small EXE file and running it to create your own signature, you can start signing your projects.
In the VBE window click Tools/Digital signature ... select your own and click OK.
Note that the signature will be removed by Excel if some one else makes changes to the code, even if that "some one else" is yourself working on another computer. However, you can copy your signature to have it installed on several computers.

Just because your project is now signed doesn't disable Excel's security concerns. You need to tell Excel that the guy behind the certificate enjoys your trust. In Excel jargon, you need to add your certificate to the list of Trusted Sources. You can look at the list of sources trusted on your computer by clicking Tools/Macro/Security and select the Trusted Publishers tab. Once your certificate's name appears in this list Excel won't ask you for clearance any more. Microsoft have published very easy-to-follow instructions for this process at this link:
http://office.microsoft.com/en-us/infopath-help/add-remove-or-view-a-trusted-publisher-HA010034138.aspx


NB. While you are looking at the Trusted Publishers list take note of the two checkboxes at the bottom. The second one says "Trust Access to Visual Basic Project". This trust is sufficiently tricky to warrant a separate post on this forum. Follow this link to read more:
http://www.excelkey.com/forum/viewtopic.php?f=7&t=637
Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 29 guests