[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 983
  • Last Modified:

Excel Trusted Source

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).
0
victornegri
Asked:
victornegri
  • 2
  • 2
1 Solution
 
mvidasCommented:
Hello,

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.

Matt
0
 
victornegriAuthor Commented:
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.

Thanks!
0
 
mvidasCommented:
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.
0
 
victornegriAuthor Commented:
Cool. I'll try it out.

Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now