skip navigation

www.Hilands.com


Content:: VBS - Remove Hyper Links

VBS - remove hyperlinks

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
Last Modified: 2010-06-03