How can I stop a pop up warning?

[Chris]

I have an excel file that gives me a warning pop up when I click on a
hyperlink that links to an executable program, but not for hyperlinks that
link to other workbooks. The pop up says:

"Some files contain viruses or otherwise be harmful to your computer.
It is important to be certain that this file is from a trustworthy source.

Would you like to open this file?"

When I created the workbook, I had the same problem, but found a simple
solution which I cannot find now. The problem started when I reinstalled XP
and Office. The file is still the same, thus I am assuming the problem is a
setting in Office.

I have searched everywhere and tried many things, but nothing has worked. I
tried digitally signing it with self certification as this seems to be the
most common solution, but that did not work. Everytime I save the file it
deletes the signature. I did something very simple before to fix the problem,
but can't remeber what it was.

Thanks for any help.

[Carim]

Hi,

Are you thinking about Tools Macro Security ... ?

HTH
Carim

[Chris]

Hi,

I have tried changing every setting in Tools Macro Security, but nothing
works.

Thanks

[JWM6]

Try these places...
http://support.microsoft.com/?kbid=288985
http://www.mcse.ms/archive145-2004-12-1266050.html

I created a local certificate for my own use, though it took a couple of tries and it seems one of the certificates I created is bad, the other one works OK.

It's 2 steps to sign the code with the digital certificate
1). Tools->Macros->Visual Basic Editor Tools->Digital Signature ---- here is where you sign your code, basically apply the digital sifgnatue to your code.
2). Tools->Macros->Security ---- set to HIGH

Hope this helps

[Chris]

Thank You for your reply

I have tried this soulution a few times now hoping that it will eventually
work. Everything seems to work fine till I try to save the signed workbork.
At that point it says "Saving will remove all digital signatures in the
workbook". And it does.

I am pretty sure I never signed the workbook before to solve this problem,
but I really can't remember. I am thinking that it may have been a Windows
tweak, but I am not really sure.

Thanks

[JWM6]

I get this too - sometimes - not sure why either. If it happens again, next time I go through the signing process, I'll make note of it and tell you what I did to get rid of the problem...

[Chris]

Thanks

I have tried to figure it out, but can't.

[JWM6]

I pulled this from another response in this forum... maybe it helps you.

I don't know if this will help your situation, but look at Excel Free and
Excel to EXE at this site.

http://cpap.com.br/orlando/

You can open your files with macros and bypass the security notice.