VBA code is the one-time code that we can regularly use whenever we want. Right-click and click on “Remove Hyperlinks.” Method #3 – Remove Hyperlink in Excel Using VBA Code Step 8: Now, all the hyperlinked cells are selected. Step 7: Exit from the “Find & Replace” window. Step 6: Now, select those using the “Shift + Down Arrow” key. Step 5: Click on “Find All.” It will display all the hyperlinked cells. Step 4: Now, select the hyperlinked cell, showing the preview in blue. Step 3: Now click on “Format” and select “Choose Format from Cell.” Ctrl+F is the shortcut for find, and Ctrl+H is the shortcut for find and replace. We can also remove hyperlinks using “ Find and Replace Excel Find And Replace Excel Find and Replace is an Excel feature that allows you to search for any text, numerical symbol, or special character not just in the current sheet but in the entire workbook. Method #2 – Remove Hyperlink in Excel Using Find and Replace In that case, there may be no solution to get rid of the message.Step 3: This can also remove the hyperlink in Excel. If you are in an enterprise environment, the setting may be controlled by a system administrator. I made the changes, but why does it still not work? Restart your Office application and the warning message about hyperlinks should no longer appear when you attempt to open files from Office applications. Close Regedit and restart the computer.In the “ Edit DWORD Value” dialog box, select “ Decimal“, and then type “ 1” under “ Value data“.In the right pane, right-click “ DisableHyperlinkWarning“, and then select “ Modify“.Type “ DisableHyperlinkWarning“, and then press “ Enter“ to name the entry.On the “ Edit” menu, point to “ New“, and then select “ DWORD Value“.Type “ Security“, and then press “ Enter“ to name the key.Select the “ Common” key, select “ New” on the “ Edit” menu, and then click “ Key“.then 16.0 (May be 15.0, 14.0 or other depending on version).Expand the plus sign next to HKEY_CURRENT_USER.Hold down the Windows Key and press “ R“.A registry edit will prevent this warning from appearing.

How to disable links in excel 2010