How Do You Stop Annoying Excel Message Boxes?

[Colin Hayes]

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

 

[carlo]

Hey Colin

ok, try following:
Right-Click on one of the Tabs of your workbook and click "view Code"
Then the VB-Editor should open.
If you don't see the Project-Explorer (usually on the left side)
press Ctrl + R.
In the Project Explorer double click on "ThisWorkbook"
and then enter the code you posted.

Try it and tell me if it works or not.

Cheers

Carlo

 

[Colin Hayes]

Hi Carlo

OK I tried it , but no joy , I'm afraid. It still pops up.

I put the code in exactly where you suggested and saved and re-opened.

It happens whenever I try to use a hyperlink to a program outside Excel.

Perhaps you could try it out yourself and see if you can get it working.
I'm sure there must be a way.


Best Wishes

 

[ilia]

Sounds like a macro security alert. If you change your setting to
lower macro security, you won't get that message.

Does the workbook you're opening contain macros?

 

[Colin Hayes]

Sounds like a macro security alert. If you change your setting to
lower macro security, you won't get that message.

Does the workbook you're opening contain macros?

Hi

I have my security set to the lowest level , and run macros without
interruption. It's an Office virus reminder which only pops up when you
try to hyperlink to an outside file or program. If you set up a
hyperlink to anything outside Excel , you'll see it pop up every time.

I read reports on the net of successful suppression , but am unable to
effect this myself.

Any help appreciated.

Best wishes.

 

[Dave Peterson]

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.

 

[Gord Dibben]

Colin

That message comes up before the workbook is opened so code will not fire.

Have a look at this KB Article for disabling that "some files may contain
viruses" message in Office 2003

http://support.microsoft.com/kb/829072/en-us


Gord Dibben MS Excel MVP

 

[Colin Hayes]

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

 

[Dave Peterson]

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\Common\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]

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

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\Common\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.

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

 

[Gord Dibben]

Colin

I will email you a small *.reg file which you can merge into the registry.

I will name it disable.txt because your email client probably won't accept
*.reg files.

After receiving it, change the extension to .reg

Right-click on it and "Merge"

Will add the DisableHyperlinksWarning with Dword value of 1


Gord

 

[Dave Peterson]

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

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

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\Common\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.

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

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

 

[Colin Hayes]

Hi Dave

OK Thanks.

Ron's page is for a different issue and wouldn't solve this one ,
unfortunately.

This a very stubborn popup. I did actually look in the registry and can
see your amendment sitting there exactly correctly , but for some reason
it's not having the desire effect. I wonder if there's some switch
elsewhere which is counter-manding it?

Best Wishes

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

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

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\Common\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

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]

I suggested looking at Ron's page to see how you'd start regedit--not for the
actual tweak.

And I don't know of any other thing to try.

Hi Dave

OK Thanks.

Ron's page is for a different issue and wouldn't solve this one ,
unfortunately.

This a very stubborn popup. I did actually look in the registry and can
see your amendment sitting there exactly correctly , but for some reason
it's not having the desire effect. I wonder if there's some switch
elsewhere which is counter-manding it?

Best Wishes

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

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

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\Common\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

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

 

[Colin Hayes]

I suggested looking at Ron's page to see how you'd start regedit--not for the
actual tweak.

And I don't know of any other thing to try.

Hi Dave

Thanks for the reg fix. It worked fine. I saw on this page that an extra
switch does sometimes needs changing to make it work in some
circumstances:

http://support.microsoft.com/kb/829072/en-us

in the Method 1: Turn off the "Confirm open after download" section

I followed this and , coupled with your fix , it did the trick. The
popups no longer appear for the file types specified.

Curious that the .exe extension doesn't appear in the Registered File
Type list , though.


Best Wishes

Hi Dave

OK Thanks.

Ron's page is for a different issue and wouldn't solve this one ,
unfortunately.

This a very stubborn popup. I did actually look in the registry and can
see your amendment sitting there exactly correctly , but for some reason
it's not having the desire effect. I wonder if there's some switch
elsewhere which is counter-manding it?

Best Wishes

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

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\Common\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

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\Secur ity

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]

Glad you got it working.

Since there is no single program associated with .exe files, I'm not surprised
it doesn't appear in that list.

I suggested looking at Ron's page to see how you'd start regedit--not for the
actual tweak.

And I don't know of any other thing to try.

Hi Dave

Thanks for the reg fix. It worked fine. I saw on this page that an extra
switch does sometimes needs changing to make it work in some
circumstances:

http://support.microsoft.com/kb/829072/en-us

in the Method 1: Turn off the "Confirm open after download" section

I followed this and , coupled with your fix , it did the trick. The
popups no longer appear for the file types specified.

Curious that the .exe extension doesn't appear in the Registered File
Type list , though.

Best Wishes

Hi Dave

OK Thanks.

Ron's page is for a different issue and wouldn't solve this one ,
unfortunately.

This a very stubborn popup. I did actually look in the registry and can
see your amendment sitting there exactly correctly , but for some reason
it's not having the desire effect. I wonder if there's some switch
elsewhere which is counter-manding it?

Best Wishes

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

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\Common\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

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\Secur ity

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

 

[Colin Hayes]

Glad you got it working.

Since there is no single program associated with .exe files, I'm not surprised
it doesn't appear in that list.

Hi Dave

Yes , true. I switched off .chm file warning no problem. Wonder how it's
possible to turn off the "Confirm open after download" for .exe files ,
given that hyperlinks out of Excel may well be to applications....

This needs to work in tandem with the .reg file you sent , so could a
second (or combined) .reg file also serve to turn off the "Confirm open
after download" for .chm , .exe files (or others) all at one go?


Best Wishes

I suggested looking at Ron's page to see how you'd start regedit--not for the
actual tweak.

And I don't know of any other thing to try.

Hi Dave

Thanks for the reg fix. It worked fine. I saw on this page that an extra
switch does sometimes needs changing to make it work in some
circumstances:

http://support.microsoft.com/kb/829072/en-us

in the Method 1: Turn off the "Confirm open after download" section

I followed this and , coupled with your fix , it did the trick. The
popups no longer appear for the file types specified.

Curious that the .exe extension doesn't appear in the Registered File
Type list , though.

Best Wishes

Colin Hayes wrote:

Hi Dave

OK Thanks.

Ron's page is for a different issue and wouldn't solve this one ,
unfortunately.

This a very stubborn popup. I did actually look in the registry and can
see your amendment sitting there exactly correctly , but for some reason
it's not having the desire effect. I wonder if there's some switch
elsewhere which is counter-manding it?

Best Wishes

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

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\Common\Secu rity]
"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

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\Se cur
ity

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

 

[Harlan Grove]

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: ....
This is really irritating , as it pops up every time. How can I stop
it popping up?

....

Another alternative that would leave standard warnings in place while
running outside .EXEs would be to use the FollowHyperlink event
handler. Name the cell that will contain the hyperlink RunEXE, insert
the hyperlink referring to the defined name RunEXE, so its own cell,
then put the following into the class module for the worksheet
containing this hyperlink.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.SubAddress = "RunEXE" Then _
Shell "c:\winnt\system32\winver.exe", vbNormalFocus
End Sub

This just runs the Windows version applet, but compare it to a
hyperlink referring directly to file:///c:\winnt\system32\winver.exe.

 

[Colin Hayes]

Another alternative that would leave standard warnings in place while

running outside .EXEs would be to use the FollowHyperlink event
handler. Name the cell that will contain the hyperlink RunEXE, insert
the hyperlink referring to the defined name RunEXE, so its own cell,
then put the following into the class module for the worksheet
containing this hyperlink.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.SubAddress = "RunEXE" Then _
Shell "c:\winnt\system32\winver.exe", vbNormalFocus
End Sub

This just runs the Windows version applet, but compare it to a
hyperlink referring directly to file:///c:\winnt\system32\winver.exe.

Hi

This is very interesting.

Could this be extended , I wonder , to cover any hyperlink within a
named range of cells? More generic , so that any hyperlink clicked with
the named range would be run?

So for example If I named B04:M26 as RunEXE, and placed several
different hypelinks within this range , could that scenario be
accommodated?


Thanks

 

[Dave Peterson]

I created the .reg file by exporting that branch while in RegEdit. You could do
the same.

I don't have a guess how to do what you want with .exe files. Maybe if you
asked in another newsgroup--dedicated to MSIE or Windows???--you may get a
better answer.

Glad you got it working.

Since there is no single program associated with .exe files, I'm not surprised
it doesn't appear in that list.

Hi Dave

Yes , true. I switched off .chm file warning no problem. Wonder how it's
possible to turn off the "Confirm open after download" for .exe files ,
given that hyperlinks out of Excel may well be to applications....

This needs to work in tandem with the .reg file you sent , so could a
second (or combined) .reg file also serve to turn off the "Confirm open
after download" for .chm , .exe files (or others) all at one go?

Best Wishes

I suggested looking at Ron's page to see how you'd start regedit--not for the
actual tweak.

And I don't know of any other thing to try.


Hi Dave

Thanks for the reg fix. It worked fine. I saw on this page that an extra
switch does sometimes needs changing to make it work in some
circumstances:

http://support.microsoft.com/kb/829072/en-us

in the Method 1: Turn off the "Confirm open after download" section

I followed this and , coupled with your fix , it did the trick. The
popups no longer appear for the file types specified.

Curious that the .exe extension doesn't appear in the Registered File
Type list , though.

Best Wishes

Colin Hayes wrote:

Hi Dave

OK Thanks.

Ron's page is for a different issue and wouldn't solve this one ,
unfortunately.

This a very stubborn popup. I did actually look in the registry and can
see your amendment sitting there exactly correctly , but for some reason
it's not having the desire effect. I wonder if there's some switch
elsewhere which is counter-manding it?

Best Wishes

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

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\Common\Secu rity]
"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

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\Se cur
ity

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