How do you disable the hyperlink warning in excel (Office 365)

0 and 1 are exactly the same decimal and Hex, see here and here

The solution that is described in the link above (adding DisableHyperlinkWarning to the win registry) might not always work.

This solution should stop hyperlink warnings in Excel for Office 365:

Download Procmon (a monitoring tool for Windows that shows real-time process/thread activity): https://technet.microsoft.com/en-us/sysinternals/processmonitor.aspx

1. Run Procmon.exe
2. Toggle Capture Events to off (File > Capture Events)
3. Clear the current events (Edit > Clear Display)
4. Toggle Capture Events on.
5. Click the desired hyperlink in Excel.
6. Turn Capture Events off.
7. Filter by Process=EXCEL.EXE (Filter > Filter, chose "Process" from the list, set field to "is", type "EXCEL.EXE" in the empty field, chose "Include" from the list and click "Add".)
8. Filter also by Operation=RegQueryValue and Result=NAME NOT FOUND
9. Find the first entry with "EditFlags" in the path (use the search icon to search the filtered list or CTRL+F)
10. Right click on that entry and select > Jump to (opens registry) 9 Add a new DWORD type named EditFlags with the hexadecimal value 10000.

In my case it was the key htmlfile_FullWindowEmbed

Modified from here

Is it changing back after restarting? if so, maybe you have some policy on your PC.

EDIT: "The option to switch between the two is purely to allow entry in either format, it is always stored in Hex and for convenience the Decimal value is shown in brackets afterward in the field view

Selecting either option would have absolutely no effect on the program accessing the value and is the same either way."

Answer from here -> https://answers.microsoft.com/en-us/windows/forum/all/problem-with-regedit-fail-trying-to-modify-dword/c6cdf515-c517-4196-8d4a-582e942f9315

The simplest solution is to use Outlook. For example, if you want to cancel the reminder when opening the embedded pptx file, you can send yourself an email with the pptx file attachment in Outlook. After receiving it, double-click the attachment to open it, and a dialog box will pop up. The following There is a check box, "Always ask before opening this type of file", uncheck it, click Open, and there will be no warning when the embedded link of this type of file is opened in ppt or excel. This method also works for other types of files. There are some settings between office components that are related to each other.

For PDF Files https://www.tek-tips.com/viewthread.cfm?qid=1363741 CreateObject opens the PDF in browser to view the file. No hyperlink warning messages An example of how CreateObject can be used

Dim wSheet As Worksheet Dim dialogBox As FileDialog Set wSheet = Sheets("Email List") Set dialogBox = Application.FileDialog(msoFileDialogOpen) dialogBox.AllowMultiSelect = False dialogBox.Title = "Select a Single File You'd Like to Open" dialogBox.InitialFileName = wSheet.Range("I9") If dialogBox.Show = -1 Then CreateObject("WScript.Shell").Run Chr(34) & dialogBox.SelectedItems(1) & Chr(34) End If