Posted to microsoft.public.excel.worksheet.functions
|
|
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
|