A Windows XP help forum. PCbanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » PCbanter forum » Windows 10 » Windows 10 Help Forum
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Removing this redundant message?



 
 
Thread Tools Rate Thread Display Modes
  #1  
Old December 11th 17, 10:14 AM posted to alt.comp.os.windows-10
Terry Pinnell[_3_]
external usenet poster
 
Posts: 732
Default Removing this redundant message?

I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to
play it:

https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I found several web articles such as this that seemed promising but
didn't work. Probably incompatible with Win 10. None of the registry
hacks like that which I've tried so far have exorcised the message.

https://support.microsoft.com/en-gb/...007-office-pro

So I'm still looking, and have posted in the Excel forum too. It's
annoying that I can't be trusted to open files I created from scratch
myself!

Can anyone here suggest a solution please?

Terry, East Grinstead, UK
Ads
  #2  
Old December 11th 17, 02:12 PM posted to alt.comp.os.windows-10
dadiOH[_3_]
external usenet poster
 
Posts: 88
Default Removing this redundant message?


"Terry Pinnell" wrote in message
...
I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to
play it:

https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I found several web articles such as this that seemed promising but
didn't work. Probably incompatible with Win 10. None of the registry
hacks like that which I've tried so far have exorcised the message.

https://support.microsoft.com/en-gb/...007-office-pro

So I'm still looking, and have posted in the Excel forum too. It's
annoying that I can't be trusted to open files I created from scratch
myself!

Can anyone here suggest a solution please?


http://www.majorgeeks.com/files/deta...n_button).html


  #3  
Old December 11th 17, 03:30 PM posted to alt.comp.os.windows-10
Paul[_32_]
external usenet poster
 
Posts: 11,873
Default Removing this redundant message?

Terry Pinnell wrote:
I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to
play it:

https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I found several web articles such as this that seemed promising but
didn't work. Probably incompatible with Win 10. None of the registry
hacks like that which I've tried so far have exorcised the message.

https://support.microsoft.com/en-gb/...007-office-pro

So I'm still looking, and have posted in the Excel forum too. It's
annoying that I can't be trusted to open files I created from scratch
myself!

Can anyone here suggest a solution please?

Terry, East Grinstead, UK


Could you export the Excel table every once in
a while as HTML, and open your table with a browser ?

https://support.office.com/en-us/art...9-CF0530AB1968

If the links were local, you would expect them to be file:\\
or similar.

It's not really a good idea to thwart Office security,
if there's a possibility of you opening a doc you
got off the Internet. If a dialog box pops up
after you open something like that, the dialog box
preventing instant execution could be a lifesaver.

Paul
  #4  
Old December 11th 17, 06:43 PM posted to alt.comp.os.windows-10
VanguardLH[_2_]
external usenet poster
 
Posts: 10,881
Default Removing this redundant message?

Terry Pinnell wrote:

I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to
play it:

https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I found several web articles such as this that seemed promising but
didn't work. Probably incompatible with Win 10. None of the registry
hacks like that which I've tried so far have exorcised the message.

https://support.microsoft.com/en-gb/...007-office-pro

So I'm still looking, and have posted in the Excel forum too. It's
annoying that I can't be trusted to open files I created from scratch
myself!

Can anyone here suggest a solution please?


Just a guess but wondering if this has to do with:

Internet Options - Advanced - Security section (at the bottom)
"Allow active content to run in files on My Computer"

With Microsoft, you can never be sure they don't borrow security from
other components in their OS or their other programs.

Issues regarding the security mechanisms with MS Office should be
addressed in a newsgroup that discusses that software. There is the
Trust Center set of options in MS Office where you can decide on how to
handle some actions.

https://support.office.com/en-us/art...8-143336039bbe

While you see "D:\path\file" in the dialog, I suspect your
*hyperlinks* actually use the file:// or another URI protocol to point
to the file. While it may seem strange, allowing links to "web" source
might also mean to any URI resource, like file://.

The article above provides help on MS Office 2013, 2010, and 2007. You
never mentioned which version of Excel that you use.
  #5  
Old December 12th 17, 12:21 AM posted to alt.comp.os.windows-10
Terry Pinnell[_3_]
external usenet poster
 
Posts: 732
Default Removing this redundant message?

VanguardLH wrote:

Terry Pinnell wrote:

I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to
play it:

https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I found several web articles such as this that seemed promising but
didn't work. Probably incompatible with Win 10. None of the registry
hacks like that which I've tried so far have exorcised the message.

https://support.microsoft.com/en-gb/...007-office-pro

So I'm still looking, and have posted in the Excel forum too. It's
annoying that I can't be trusted to open files I created from scratch
myself!

Can anyone here suggest a solution please?


Just a guess but wondering if this has to do with:

Internet Options - Advanced - Security section (at the bottom)
"Allow active content to run in files on My Computer"

With Microsoft, you can never be sure they don't borrow security from
other components in their OS or their other programs.

Issues regarding the security mechanisms with MS Office should be
addressed in a newsgroup that discusses that software. There is the
Trust Center set of options in MS Office where you can decide on how to
handle some actions.

https://support.office.com/en-us/art...8-143336039bbe

While you see "D:\path\file" in the dialog, I suspect your
*hyperlinks* actually use the file:// or another URI protocol to point
to the file. While it may seem strange, allowing links to "web" source
might also mean to any URI resource, like file://.

The article above provides help on MS Office 2013, 2010, and 2007. You
never mentioned which version of Excel that you use.


dadiOH: Thanks, but couldn't get that to work with any reliability.

Paul, Vanguard: Thanks both, appreciate the replies.

See this illustration to remove any ambiguity:
https://www.dropbox.com/s/cbvbkzti76...age-2.jpg?dl=0

No internet involvement. As mentioned, these are local files I created
myself.

I'd already opened a thread in the Excel forum

I had tried Excel 365's Trust Centre settings. Not confident I've done
it correctly but it had no effect:
https://www.dropbox.com/s/tzo2f4ztnm...age-3.jpg?dl=0

Terry, East Grinstead, UK
  #6  
Old December 12th 17, 01:42 AM posted to alt.comp.os.windows-10
Paul[_32_]
external usenet poster
 
Posts: 11,873
Default Removing this redundant message?

Terry Pinnell wrote:
VanguardLH wrote:

Terry Pinnell wrote:

I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to
play it:

https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I found several web articles such as this that seemed promising but
didn't work. Probably incompatible with Win 10. None of the registry
hacks like that which I've tried so far have exorcised the message.

https://support.microsoft.com/en-gb/...007-office-pro

So I'm still looking, and have posted in the Excel forum too. It's
annoying that I can't be trusted to open files I created from scratch
myself!

Can anyone here suggest a solution please?

Just a guess but wondering if this has to do with:

Internet Options - Advanced - Security section (at the bottom)
"Allow active content to run in files on My Computer"

With Microsoft, you can never be sure they don't borrow security from
other components in their OS or their other programs.

Issues regarding the security mechanisms with MS Office should be
addressed in a newsgroup that discusses that software. There is the
Trust Center set of options in MS Office where you can decide on how to
handle some actions.

https://support.office.com/en-us/art...8-143336039bbe

While you see "D:\path\file" in the dialog, I suspect your
*hyperlinks* actually use the file:// or another URI protocol to point
to the file. While it may seem strange, allowing links to "web" source
might also mean to any URI resource, like file://.

The article above provides help on MS Office 2013, 2010, and 2007. You
never mentioned which version of Excel that you use.


dadiOH: Thanks, but couldn't get that to work with any reliability.

Paul, Vanguard: Thanks both, appreciate the replies.

See this illustration to remove any ambiguity:
https://www.dropbox.com/s/cbvbkzti76...age-2.jpg?dl=0

No internet involvement. As mentioned, these are local files I created
myself.

I'd already opened a thread in the Excel forum

I had tried Excel 365's Trust Centre settings. Not confident I've done
it correctly but it had no effect:
https://www.dropbox.com/s/tzo2f4ztnm...age-3.jpg?dl=0

Terry, East Grinstead, UK


The topic is addressed here, but I don't know if you'll like the answer or not.

https://support.microsoft.com/en-us/...007-office-pro

The warning you're getting, is caused by the file extension indicating
a file type with exploit potential. It probably isn't an Alternate Stream
attached to the file that marks it as "downloaded from the Internet", and
instead, is a check of whether it's a file type that has known exploits.
The JPG and TIF libraries were bugged at one time, and multiple platforms
and programs used the open source libraries for those, without doing
a code inspection. I'm sure I've still got programs here, which are
vulnerable to attacks on those "features" (program links to the older
"unfixed" versions of those libraries).

The MP4 is probably the same thing - some CODEC which has issues and
suffers stack overflow or somesuch, and the warning is an attempt
to protect you (they're warning you of the remote possibility and
are not actually detecting an exploit-in-motion).

You would think the Alternate Stream marker would be
sufficient, as that would give the user an opportunity to mark files
as "Yes, I know where this came from and... I approve". It's not clear
in that article, whether their registry adjustments do enough to
entirely eliminate the symptoms. So you'll have to test it.

Paul
  #7  
Old December 12th 17, 03:35 PM posted to alt.comp.os.windows-10
Terry Pinnell[_3_]
external usenet poster
 
Posts: 732
Default Removing this redundant message?

Paul wrote:

Terry Pinnell wrote:
VanguardLH wrote:

Terry Pinnell wrote:

I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to
play it:

https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I found several web articles such as this that seemed promising but
didn't work. Probably incompatible with Win 10. None of the registry
hacks like that which I've tried so far have exorcised the message.

https://support.microsoft.com/en-gb/...007-office-pro

So I'm still looking, and have posted in the Excel forum too. It's
annoying that I can't be trusted to open files I created from scratch
myself!

Can anyone here suggest a solution please?
Just a guess but wondering if this has to do with:

Internet Options - Advanced - Security section (at the bottom)
"Allow active content to run in files on My Computer"

With Microsoft, you can never be sure they don't borrow security from
other components in their OS or their other programs.

Issues regarding the security mechanisms with MS Office should be
addressed in a newsgroup that discusses that software. There is the
Trust Center set of options in MS Office where you can decide on how to
handle some actions.

https://support.office.com/en-us/art...8-143336039bbe

While you see "D:\path\file" in the dialog, I suspect your
*hyperlinks* actually use the file:// or another URI protocol to point
to the file. While it may seem strange, allowing links to "web" source
might also mean to any URI resource, like file://.

The article above provides help on MS Office 2013, 2010, and 2007. You
never mentioned which version of Excel that you use.


dadiOH: Thanks, but couldn't get that to work with any reliability.

Paul, Vanguard: Thanks both, appreciate the replies.

See this illustration to remove any ambiguity:
https://www.dropbox.com/s/cbvbkzti76...age-2.jpg?dl=0

No internet involvement. As mentioned, these are local files I created
myself.

I'd already opened a thread in the Excel forum

I had tried Excel 365's Trust Centre settings. Not confident I've done
it correctly but it had no effect:
https://www.dropbox.com/s/tzo2f4ztnm...age-3.jpg?dl=0

Terry, East Grinstead, UK


The topic is addressed here, but I don't know if you'll like the answer or not.

https://support.microsoft.com/en-us/...007-office-pro

The warning you're getting, is caused by the file extension indicating
a file type with exploit potential. It probably isn't an Alternate Stream
attached to the file that marks it as "downloaded from the Internet", and
instead, is a check of whether it's a file type that has known exploits.
The JPG and TIF libraries were bugged at one time, and multiple platforms
and programs used the open source libraries for those, without doing
a code inspection. I'm sure I've still got programs here, which are
vulnerable to attacks on those "features" (program links to the older
"unfixed" versions of those libraries).

The MP4 is probably the same thing - some CODEC which has issues and
suffers stack overflow or somesuch, and the warning is an attempt
to protect you (they're warning you of the remote possibility and
are not actually detecting an exploit-in-motion).

You would think the Alternate Stream marker would be
sufficient, as that would give the user an opportunity to mark files
as "Yes, I know where this came from and... I approve". It's not clear
in that article, whether their registry adjustments do enough to
entirely eliminate the symptoms. So you'll have to test it.

Paul


Sorted!

I wrote a simple Macro Express Pro script activated by the opening of
the window 'Microsoft Office'. I'd hesitated in trying that obvious
approach not only because it's crude but also because I was unduly
pessimistic about its speed. In fact it takes maybe only about a quarter
of a second between clicking the cell and seeing the video open. Still
long enough to see the darned thing, of course, but I'll settle for that
until someone fixes it properly.

Terry, East Grinstead, UK
  #8  
Old December 12th 17, 07:46 PM posted to alt.comp.os.windows-10
VanguardLH[_2_]
external usenet poster
 
Posts: 10,881
Default Removing this redundant message?

Terry Pinnell wrote:

I wrote a simple Macro Express Pro script activated by the opening of
the window 'Microsoft Office'. I'd hesitated in trying that obvious
approach not only because it's crude but also because I was unduly
pessimistic about its speed. In fact it takes maybe only about a quarter
of a second between clicking the cell and seeing the video open. Still
long enough to see the darned thing, of course, but I'll settle for that
until someone fixes it properly.


Isn't that similar (but perhaps less coding effort) to what dadiOH
already suggested?
  #9  
Old December 13th 17, 11:00 AM posted to alt.comp.os.windows-10
Terry Pinnell[_3_]
external usenet poster
 
Posts: 732
Default Removing this redundant message?

VanguardLH wrote:

Terry Pinnell wrote:

I wrote a simple Macro Express Pro script activated by the opening of
the window 'Microsoft Office'. I'd hesitated in trying that obvious
approach not only because it's crude but also because I was unduly
pessimistic about its speed. In fact it takes maybe only about a quarter
of a second between clicking the cell and seeing the video open. Still
long enough to see the darned thing, of course, but I'll settle for that
until someone fixes it properly.


Isn't that similar (but perhaps less coding effort) to what dadiOH
already suggested?


Yes, but mine works ;-)

Terry, East Grinstead, UK
  #10  
Old December 13th 17, 11:37 AM posted to alt.comp.os.windows-10
Terry Pinnell[_3_]
external usenet poster
 
Posts: 732
Default Removing this redundant message?

Terry Pinnell wrote:

I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to
play it:

https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I found several web articles such as this that seemed promising but
didn't work. Probably incompatible with Win 10. None of the registry
hacks like that which I've tried so far have exorcised the message.

https://support.microsoft.com/en-gb/...007-office-pro

So I'm still looking, and have posted in the Excel forum too. It's
annoying that I can't be trusted to open files I created from scratch
myself!

Can anyone here suggest a solution please?

Terry, East Grinstead, UK


SUMMARY of methods I've tried to remove the redundant message
================================================== ===========

Suggestion #1
-------------
https://www.technipages.com/disable-...d-data-message

Expand the plus sign next to HKEY_CURRENT_USER

then Software
then Policies
then Microsoft
then Office
then 16.0
then Common

Select the “Common” key, select “New” on the “Edit” menu, and then click
“Key“.
Type “Security“, and then press “Enter“ to name the key.
On the “Edit” menu, point to “New“, and then select “DWORD Value“.
Type “DisableHyperlinkWarning“, and then press “Enter“ to name the
entry.
In the right pane, right-click “DisableHyperlinkWarning“, and then
select “Modify“.
In the “Edit DWORD Value” dialog box, select “Decimal“, and then type
“1” under “Value data“.
Close Regedit and restart the computer.

TRIED. Still get the redundant message.

Suggestion #2
-------------
https://support.microsoft.com/en-gb/...007-office-pro

Or
http://www.thewindowsclub.com/disabl...arnings-office

To enable or to disable the hyperlink warnings in 2007 Office programs
and in Office 2010 programs when an http:// address, a notes:// address,
or an ftp:// address is used, you must create a new registry subkey. To
do this, follow these steps:

Click Start, and then click Run.
In the Open dialog box, type regedit, and then click OK.

Notes
You have to modify only one of these registry subkeys. You do
not have to modify both.
If the Security subkey already exists, go directly to step 6
after you select the Security subkey.
In Registry Editor, locate one of the following registry subkeys for
2007 Office:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon
Or, in Registry Editor, locate one of the following registry subkeys
for Office 2010:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\C ommon
Click the registry subkey, point to New on the Edit menu, and then
click Key.
Type Security, and then press Enter to name the key.
On the Edit menu, point to New, and then click DWORD Value.
Type DisableHyperlinkWarning, and then press Enter to name the
entry.
In the right pane, right-click DisableHyperlinkWarning, and then
click Modify.
In the Edit DWORD Value dialog box, click Decimal, and then type 1
or 0 under Value data.

Note A value of 0 enables the hyperlink warning message. A value of
1 disables the hyperlink warning message.
Click OK.

TRIED (modified by adding key to 16.0 because I use Excel 365). Still
get the redundant message.

Suggestion #3
-------------
https://getadmx.com/?Category=Office...erlinkwarnings

EXCEL Options Trust Center Trusted Locations Add new location...
The files whose hyperlinks I am opening (and getting the daft message)
are all in sub-folders beneath D:\Videos+Projects. I therefore added
that to the 'User Locations' section. I don't understand the 'Policy
Locations' section, which is currently empty.

TRIED. Still get the redundant message. (I also tried enabling 'Allow
Trusted Locations on my network (not recommended)' even though I don't
really understand it in this context, but no change there either.
Unchecked that subsequently.

Terry, East Grinstead, UK
 




Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off






All times are GMT +1. The time now is 01:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 PCbanter.
The comments are property of their posters.