Trusting a file in macro security

[foxguy]

In Excel 2007, is there any way to mark a file as "Trusted", so I don't have to keep SECURITY WARNING>OPTIONS>ENABLE every time I open the file?

Edit:

I found Trust Center > Trusted Locations, but is there a way to mark an individual file instead of the entire folder?

[MarvinP]

Hey foxguy,

Have you read http://faculty.fuqua.duke.edu/~peckl...20security.pdf yet?

hth

[foxguy]

I hadn't read that particular page, but I already knew everything it says.

I don't think it's possible, but I would like to be able to somehow mark a particular file (not a folder) as trusted, so I don't have to move it into a trusted folder. I was hoping that I had missed something somewhere that would allow me to mark a file.

[MarvinP]

I was looking at the "Trust All Documents from this Publisher" radio button.

I believe you can Create your own personal Digital Certificate and then go from there.

See:
http://office.microsoft.com/en-us/ex...CH101001571033

Also the look at SelfCert.exe which should be on your machine. The dialog claims "A self-signed certificate is only for personal use.

Is this what you were looking for?

[foxguy]

Thanks Marvin;

That looks like what I was looking for.

[royUK]

In 2007 & 2010 you can create Trusted Folders