Delete all Hyperlinks on a Sheet in Excel

From Relyimah

Jump to: navigation, search

Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press <ALT>-F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.

Paste the following code into your new module: 

Sub RemoveHyperlinks()
    'Remove all hyperlinks from the active sheet
    ActiveSheet.Hyperlinks.Delete
End Sub

Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.

Now, go to the sheet that contains the hyperlinks that you wish to delete.

  • Under the Tools menu, select Macro > Macros. Highlight the macro called "RemoveHyperlinks" and click on the Run button.
  • Now your hyperlinks should be deleted.

If you need to remove hyperlinks from other sheets, just repeat the steps above.


Source: Excel: Delete all hyperlinks on a sheet in Excel 2003/XP/2000/97 (Accessed: 2008-03-13)

Retrieved from "http://wiki.relyimah.com.au/index.php5/Delete_all_Hyperlinks_on_a_Sheet_in_Excel"
Personal tools