![]() If you often have the need to remove hyperlinks from a worksheet (or a selected range), it’s a good idea to save this macro in your personal macro workbook. If you don’t want to remove all the hyperlinks in a worksheet, but only the ones in the selected range, use the below VBA code: Sub RemoveHyperlinksfromSelection() Now to remove all the hyperlinks from the worksheet, all you need to do is click on the macro in the QAT. The above steps would add the macro to the QAT.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |