Enable macro recording: Tools/Options/Advanced Tick box at bottom right. Find: (https://.*) Replace: =hyperlink("&") Check "Regular expressions", "Search in formula" Replace all Close Name Macro HyperAdd, put under My macros/Standard/Module1 View/toolbar/customize keyboard tab under Category, scroll down to Application macors/my marcos.Standard/Module 1 In top box/ find and click on ^H, then hit Modify and OK Now ^H inserts hyperlinks.