Live URL links in excel

  • Thread starter Thread starter Don Niall
  • Start date Start date
D

Don Niall

Hi,

Is there a way to deactivate live URL links in an Excel
s/s? I am working with a s/s presently that has many
fields containing live URL links - and inadvertently am
constantly triggering them ....

Don-
 
Two things you could do:

1. When you click on each cell, click and hold the click down for a second
or so, and the link will not activate, and allow you to select the cell.

2. Use a macro to remove the hyperlinks (but leave the text in the cell). To
do this, open the VBA editor (Alt + F11), insert a blank VBA module (Insert,
Module), and copy and paste the following code into the module:

Sub dog()
For Each Cell In Selection
Selection.Hyperlinks.Delete
Next Cell
End Sub

Now return to worksheet area, highlight the range of cells that have
hyperlinks (doesn't matter if you also catch some cells without hyperlinks).
Leave highlighted, then hit Alt + F8, select and run the macro called dog.
That should remove the hyperlinks....

MRO
 
Back
Top