Monday, September 10, 2007

How to Unlink Every Hyperlink in a Microsoft Excel Document ?

After the last article "How to Unlink Every Hyperlink in a Microsoft Word Document ?", one of my friend's asked me for a solution to do the same in a Microsft Excel Document. Volla, here's how it can be done in an Excel file. The Macro code is changed - else all the steps are the same.

Running the following macro achieves the same result as selecting each hyperlink and choosing Remove Hyperlink from the shortcut menu.

Here we go with the steps:
  • In Excel, click to Tools > Macro > Visual Basic Editor (or press F11)
  • Right-click the ThisWorkbook icon , then select Insert > Module
  • Paste the code below into the box. Click File > Save. Alternately, you can save this macro in a template of your choice


Sub RemoveAllHyperlinks()
ActiveWorkbook.ActiveSheet.Hyperlinks.Delete
End Sub


Run this macro in Excel from the Tools > Macro > Macros dialog.

Hope this helps.

1 comment: