Delete all hyperlinks on a sheet

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.

September 28, 2007 | Filed Under Tech | Leave a Comment 
Your Ad Here

backup blogging web hosting transition server space Tech Ed SEA 2008 Windows XP Service Pack 3 WinFax Tech·Ed SEA 2008 Limited Edition T-shirt Tweak Putty Registry Wine Security IP freebies Microsoft TechEd SEA 2008 hosting contest phishing VMware DHCP Freeware Photography router Network Cisco Microsoft Ubuntu Linux