www.Hilands.com :: Computer Information Dump

Content:: VBS - Remove Hyper Links

I found a bit of code on techonthenet.com to assist with removing hyperlinks from a microsoft excel spreadsheet.

From the excel window open the Microsoft Visual Basic Editor. Select Tools from the menu bar and scroll down to the Macro menu item. From the Sub menu select Visual Basic Editor (shortcut key ALT+F11).

We will need to create a new module. Inside the Microsoft Visual Basic editor select the Insert option from the menu bar and select Module.

Insert the following code

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

Upon closing the window you will now have a new macro called RemoveHyperLinks. From your excel spreadsheet select Tools > Macro > Macros...from the menu bar and run the RemoveHyperlinks macro.

References
http://www.techonthenet.com/excel/macros/delete_hl.php