How to remove all hyperlinks from a worksheet in Excel?
 

I have many HyperLinks on one of my worksheets, which I want to remove them
all. I'm sure EXCEL has a single command to do this but I can't find it!
Please help.
Regards - Amos )

try --------------activesheet.hyperlinks.delete (not tested)


Amos wrote in message
...
I have many HyperLinks on one of my worksheets, which I want to remove
them
all. I'm sure EXCEL has a single command to do this but I can't find it!
Please help.
Regards - Amos )

Amos

This code in a standard module will delete all hyperlinks on the activesheet

You might want to add it to your personal.xls if you use it often

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Amos" wrote in message
...
I have many HyperLinks on one of my worksheets, which I want to remove them
all. I'm sure EXCEL has a single command to do this but I can't find it!
Please help.
Regards - Amos )

And I bet that code looks something like this:

Option Explicit
sub RemoveHyperLinks
activesheet.cells.hyperlinks.delete
end sub

Nick Hodge wrote:

Amos

This code in a standard module will delete all hyperlinks on the activesheet

You might want to add it to your personal.xls if you use it often

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Amos" wrote in message
...
I have many HyperLinks on one of my worksheets, which I want to remove them
all. I'm sure EXCEL has a single command to do this but I can't find it!
Please help.
Regards - Amos )

--

Dave Peterson

Dave

Ooops...now is it still on the clipboard ;-)

Sub DeleteHyperlinks()
Cells.HyperLinks.Delete
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dave Peterson" wrote in message
...
And I bet that code looks something like this:

Option Explicit
sub RemoveHyperLinks
activesheet.cells.hyperlinks.delete
end sub

Nick Hodge wrote:

Amos

This code in a standard module will delete all hyperlinks on the
activesheet

You might want to add it to your personal.xls if you use it often

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Amos" wrote in message
...
I have many HyperLinks on one of my worksheets, which I want to remove
them
all. I'm sure EXCEL has a single command to do this but I can't find
it!
Please help.
Regards - Amos )

--

Dave Peterson