How can I disable all hyperlinks in a spreadsheet?
 

I copy data from other spreadsheets. If it look slike an address Excel makes
it a hyper link. I have to remove them one by one - then they come back when
I copy data from that cell. How can I stop this for good without downgrading
to an older version?

How can I disable all hyperlinks in a spreadsheet?
 

If you paste special as values they won't be hyperlinks, if you have a lot
of hyperlinks that you
want to make inactive in one fell swoop you can copy an empty cell, then
select the links(using arrow keys)
and then paste special and select add

--


Regards,


Peo Sjoblom



"Badger Blue" <Badger wrote in message
...
I copy data from other spreadsheets. If it look slike an address Excel
makes
it a hyper link. I have to remove them one by one - then they come back
when
I copy data from that cell. How can I stop this for good without
downgrading
to an older version?

How can I disable all hyperlinks in a spreadsheet?
 

Run this tiny macro:

Sub hyperbegone()
Cells.Hyperlinks.Delete
End Sub

--
Gary''s Student - gsnu200788