Trusted Publisher in Excel 2003

  • Thread starter Thread starter Howard Brazee
  • Start date Start date
H

Howard Brazee

I used SelfCert.exe to make myself trusted, I ran it twice, once
saying I was Brazee, and once saying I was Howard Brazee.

But when I open my spreadsheet with medium security that is in:
C:\Documents and Settings\brazee\My Documents\home

I get the medium security dialog asking if I want to enable macros.

I look at Tools|Macros|Security|Trusted Publishers

and see brazee is a trusted publisher. Both check boxes are checked.

I found another spreadsheet I created a year ago (with macros), and it
appears to have the exact same settings. (That's when I learned
about SelfCert).

What am I missing?
 
Did you digitally sign your macros?
From VB Editor, Tools -> Digital Signature -> Choose. Save the file.
Click to expand...

The next time it opens, you can check the box to Always Trust, and
after that it will open silently.

If the Always Trust box is grayed out, it can be enabled by installing
it:
Details -> View Certificate -> Install or a variation thereof.

Carl
 
Did you digitally sign your macros?
Click to expand...

I didn't see that message. It was what I needed. I noticed I had a
half dozen signatures from all of the times I tried SelfCert.
 
Back
Top