View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How Do You Stop Annoying Excel Message Boxes?

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.

Colin Hayes wrote:

In article , Dave Peterson
writes
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


Colin Hayes wrote:

In article , Dave Peterson
writes
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

In article , Dave Peterson
writes
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\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

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






--

Dave Peterson