removing more than one hyperlink

  • Thread starter Thread starter dkb43
  • Start date Start date
D

dkb43

I have an import into Excel that involves 1000 records. Each record has one
important field has a hyperlink, thus 1000 hyperlinks. In Excel 2000, how do
I remove the hyperlinks. Right now the only method I can find is to remove 1
hyperlink, then move with the down arrow and use F4. Twenty records might
work fine that way, but 1000 is way too many.

Thanks!
Deb
 
hi
high light the field and run this macro...
Sub removehyperlink()
Selection.Hyperlinks.Delete
End Sub

regards
FSt1
 
1:Put 1 in any blank Cell copy the cell.Select the Column.Then go to
Edit<Paste Special<Click Multiply <OK.

2: Ctrl +A Twice Alt +F11< Ctrl +G
Type: Selection.hyperlinks.delete

Then Enter

Press Alt+Q to Return to Excel

Hardeep kanwar
 
Back
Top