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

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