' Purpose: Removes the hyperlinks from the selected range leaving the text. ' Copyright 2011-2012 TNG Consulting Inc.
TURN OFF AUTOMATIC HYPERLINKS IN EXCEL 2016 CODE
Paste the above code into the project module you have selected.Right-click on it, select Insert and then Module. Look for the folder called Microsoft Excel Objects.In the View and select Project Explorer.Open the macro editor by pressing ALT+F11.If Left(Trim(Cell), 4) = "http" Then ' handles http and httpsĪ Cell, Trim(Cell.Value)Įlse ' Default to http if no protocol was specified.Ī Cell, " & Trim(Cell.Value) ' Note: HTTP is assumed if not specified in the text.įor Each Cell In Intersect(Selection, ActiveSheet.UsedRange) ' Purpose: Converts the selected text into hyperlinks. ' Copyright 2011-2012 TNG Consulting Inc. Note that this method only works if the workbook is in single user mode, not multi-user shared mode. When executed, it will go through the selected range of cells and turn them all into hyperlinks. The second way is to use VBA and then run the macro. Method #2: Using VBA to convert text into hyperlinks (advanced) Of course you could create a more complex formula that could automatically detect whether is required but those above are easier to remember. Note that if your URL does not start with " you will need to add it as follows: The first parameter is the cell address that contains the URL and the second refers to the text you want to have appear in the cell. This first method uses a formula to create a hyperlink enable version of the cell in an adjacent cell: Method #1: Use an Excel formula to create hyperlinks Note that neither of these two methods do any validating to ensure the result is actually a valid hyperlink.
TURN OFF AUTOMATIC HYPERLINKS IN EXCEL 2016 FULL
Have you ever had an Excel spreadsheet full of web addresses that were not clickable? Pressing F2 and ENTER is good enough when you only have a few, but when you have dozens, hundreds or even thousands, this can become a very time consuming task.įortunately there are a couple of approaches which will save you tons of time.