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. 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). MS Excel 2003: Delete all hyperlinks on a sheet
0 Comments
Leave a Reply. |