Are you looking for an easy and yet effective method of removing hyperlinks from you worksheet? By using Visual Basic for Excel the following code will remove all hyperlinks from the worksheet.
Visual Basic Coding:
Sub RemoveHyperlinks()
Activesheet.Hyperlinks.Delete
End Sub
Sometimes a copy and paste of internet based materials can also bring across embedded hyperlinks. Follow the example below as we explain how you can quickly remove hyperlinks from a worksheet.
Applies To: MS Excel 2003, 2007 and 2010
- Ensure you are on the worksheet you would like to remove the hyperlinks from
- Press ALT+F11 to open the Visual Basic Editor
- From the Menu bar, select Insert Module
- Copy and paste the above coding into the window on the right
- From the Menu bar, select File, Close and Return to MS Excel
- Press ALT + F8 to view a list of Macros
- Select the Macro, RemoveHyperlinks
- Select Run
If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.
Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations
