Excel – How to Remove Multiple Hyperlinks by Using a Macro

excel_logoI’ve seen many other places on the internet where an item doesn’t show up, requires a plugin, or that the version of Microsoft Office isn’t compatible. This macro solution actually works.

Step 1. Press Alt + F11 to start the Visual Basic Editor.

Step 2. Double click the workbook you are using on the Project Explorer and type the following code:

Sub RemoveHyperlinks() 
ActiveSheet.Hyperlinks.Delete 
End Sub

Step 3. Save your work. Note: if you’re using Excel 2007 or higher it may ask you to save the workbook as .xlsm. If this is only a one-time thing you should just save your workbook “as is.”

Step 4. Run the macro by pressing Alt + F8 or using the menu by View > Macros

Step 5. Select the macro you have made, it should have the name ‘RemoveHyperlinks’.

Comments

comments

Recent Posts