How do I temporarily disable hyperlinks in an excel sheet?
 

I have a lot of hyperlinks in my excel sheet. I need those link, but I really
wish they wouldn't open the second I click on them. Is there anyway to disble
them temporarily or at least make it so I have to ctrl+click?
I have excel 2000.

How do I temporarily disable hyperlinks in an excel sheet?
 

This technique will work if your hyperlinks were implemented using the
=HYPERLINK() function. Run this first macro:

Sub stopum()
dq = Chr(39)
For Each r In ActiveSheet.UsedRange
v = r.Formula
If Left(v, 6) = "=HYPER" Then
MsgBox (r.Address)
r.Formula = dq & v
End If
Next
End Sub

This will convert all the hyperlinks into text. To return to "active"
hyperlinks, run the second macro:

Sub startum()
dq = Chr(39)
For Each r In ActiveSheet.UsedRange
v = r.Formula
If Left(v, 6) = "=HYPER" Then
r.Formula = r.Formula
End If
Next
End Sub


This method will NOT work if your hyperlinks were implemented using:
Insert Hyperlink
--
Gary''s Student - gsnu200759


"looloof" wrote:

I have a lot of hyperlinks in my excel sheet. I need those link, but I really
wish they wouldn't open the second I click on them. Is there anyway to disble
them temporarily or at least make it so I have to ctrl+click?
I have excel 2000.