![]() ![]() To run the macro, select the spreadsheet you need to remove hyperlinks from, press the Alt + F8 hotkey to open a Macro window, select ThisWorkbook.RemoveAllHyperlinks from the Macro window and then press the Run button.Įxcel automatically converts URLs to links.Now, copy and paste the code below into the VB code window with the Ctrl + C and Ctrl + V hotkeys: ‘ Code to Remove Hyperlinks in Excel Sub RemoveAllHyperlinks().Then you can double-click ThisWorkbook on the VBAProject panel. ![]() Press the Alt + F11 hotkey to open the VB editor in Excel.So why not set up a macro that removes all hyperlinks from an Excel sheet? The full Excel application includes a macro-recording tool to record macros with, but you can also set up macros by manually entering the Visual Basic code. This Tech Junkie post (and its video) tells you how to record macros in Windows. Macros are a recorded sequence of selected options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |