Remove hyperlinks in an entire column in excel

[Christian]

How do I remove hyperlinks in an entire column in excel

 

[Don Guillett]

try

sub gg
activecell.entirecolumn.hyperlinks.delete
end sub

 

[Doug]

Deactivate several hyperlinks at once:

Type the number 1 in a blank cell, and right-click the cell.

Click Copy on the shortcut menu.

While pressing CTRL, select each hyperlink you want to deactivate.

(To select a cell that has a hyperlink in it without jumping to the
hyperlink destination, click the cell and hold the mouse button until
the cursor becomes a cross , then release the mouse button.)

Click Paste Special on the Edit menu.

Under Operation, click Multiply and then click OK.