I don't have a guess.

Maybe reading the link to the MSKB article that Gord posted would help?

Ron de Bruin is updating his site for a different registry tweak.

He has some pictures of how to do this tweaking--but for a different key. It
may help.

http://www.rondebruin.nl/password2007.htm

Colin Hayes wrote:

H Dave

Thanks for this. Didn't work though , unfortunately.

I pasted the text , and saved as you suggested and ran it. It asked me
if I really wanted to enter this information into the registry , so I
clicked OK and then it said that it had successfully entered the
information.

I rebooted and .... I still get the popup! How frustrating!

It's definitely xl2003 I'm running.

What do you think?

Best Wishes

In article , Dave Peterson
writes
This is specific to xl2003.

Open Notepad
Paste the following 3 lines:

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\C ommon\Security]
"DisableHyperlinkWarning"=dword:00000001

Save that file with an extension of .reg (DisableHyperWarning.Reg, for example)

Double click on that .reg file and you should get a message back whether it was
successful or not.

Colin Hayes wrote:

Hi Dave

OK Thanks for that. I think we're a little closer now.

Is there a small batch or .exe file in existence to carry out these
steps automatically , I wonder? Or would it be hard to create one? I'm
a little wary of going into the registry myself and changing things
around like this.

Best Wishes

Colin

In article , Dave Peterson
writes
What version of excel are you using.

You can tweak the windows registry in xl2003 and stop that warning.

Saved from a Jim Rech post:

Close Excel
Windows start button|Run
Regedit
(click ok)

Navigate to this key in the left panel:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\ Common\Security

If you do not have a Security key under Common (I didn't) create it by
right-clicking on Common and picking New and Key. Give it the name
Security.

After creating Security, select it in the left panel and in the empty right
panel right-click anywhere and select New and Dword value. Give it the
name: DisableHyperlinkWarning

and press Enter. This entry will have the value 0. Double-click it and
change the value to 1 and press Enter.

You can close Regedit. And Excel 2003 should not give the warning any
more.

Colin Hayes wrote:

I have a worksheet with a hyperlink to a program outside Excel. This is
working fine at this point with one exception. Every time you click on
the link Excel puts up a message box stating the following:

€ŀœSome files can 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?€?

This is really irritating , as it pops up every time. How can I stop it
popping up?

I looked on the net and somebody suggested this might work :

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = True
End Sub

Private Sub Workbook_Open()
Application.DisplayAlerts = False
End Sub

The problem is that i would have no idea where to place this , or enact
it , in Excel. Can someone help?

Thanks



--

Dave Peterson