Excel Trusted Source

Posted on 2006-05-22
Last Modified: 2012-08-14
Whenver you open an Excel document with a macro embedded, a warning message pops up that asks you whether it's from a trusted source or not. How do I sign the document so that it is from a known trusted source? (BTW, I do not want to lower the security settings in Excel).
Question by:victornegri
    LVL 35

    Accepted Solution


    You need to attach a digital certificate to the VBA code (using Tools / Digital Certificate), and then you can keep it on higher security without the macro warning.  If you do not want to purchase an actual certificate (there are a few places out there that issue them), search your computer for SELFCERT.EXE to create your own for free.  It won't be verified, but if only you or a small distribution group that trusts you are using the file, it should be fine.

    It doesn't get installed by default with office, it is an optional component.  If you don't have it, you may need to add that component using the office setup cd.

    LVL 10

    Author Comment

    Will I be able to distribute this file across the domain? The name selfcert.exe implies that this certificate is for myself (personal cert store?). The Excel document is going to be accessed by a web based app and open up in IE.

    I'll see whether my client has already purchased a digital cert from a trusted authority.

    LVL 35

    Expert Comment

    Selfcert just generates a certificate to yourself, but it is distributable.  That is what I use for the vba I create for my group, though it isn't opened in IE.  As long as you attach the certificate, whether an actual cert or a self-created cert, it will be considered a trusted source as long as the user adds you as a trusted source.
    LVL 10

    Author Comment

    Cool. I'll try it out.


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
    The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
    The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now