If you need to remove hyperlinks from other sheets, just repeat the steps above. Now your hyperlinks should be deleted as you can see by the example below: Highlight the macro called 'RemoveHyperlinks' and click on the Run button. Under the Tools menu, select Macro > Macros. Here is an example of a sheet with multiple hyperlink addresses: Now, go to the sheet that contains the hyperlinks that you wish to delete. 'Remove all hyperlinks from the active sheetĬlose the Visual Basic editor window by selecting 'Close and Return to Microsoft Excel' under the File menu. Paste the following code into your new module: Sub RemoveHyperlinks() You can do this by selecting Module under the Insert menu. Press Alt+ F11 to go to the Visual Basic editor.

Open your Excel spreadsheet that you wish to remove the hyperlinks from. How can I delete all hyperlinks in a sheet at once and not have to delete them cell by cell?Īnswer: You will need to create a macro to delete the hyperlink addresses in your Excel sheet. Question: In Microsoft Excel 2003/XP/2000/97, I've had a hyperlink problem in my Excel files for ages: false hyperlinks had crept in (even in empty cells) and were multiplying regularly whenever I inserted new lines. I am contracting and trying to get work out and this has now caused huge problems. Yesterday it flicked back to only giving me the option to open in 2003-2007 workbook so now I am having issues with the macros. I needed to open excel documents via email with the macro enabled option. This Excel tutorial explains how to write a macro to delete all hyperlinks on a sheet in Excel 2003 and older versions (with screenshots and step-by-step instructions). I have recently installed Office 365 and it was working great. MS Excel 2003: Delete all hyperlinks on a sheet

Disable macros in excel 2003