removing more than one hyperlink

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
 
F

FSt1

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

regards
FSt1
 
H

Hardeep_kanwar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use Hyperlink to open Folders? 0
How to prevent email addresses from becoming hyperlinks, and removinghyperlink 1
Hyperlink list in excel 1
hyperlink 0
hyperlink 0
Send a command down a column 2
multiple Hyperlink address change 2
How can i remove the several hyperlink option after entering the . 1

Top