Excel 2003 - Turning off hyperlinks?

[Paul B]

Hi

Advice appreciated - When I copy and paste data phrases with hyperlinks into
excel 2003 i.e. several hundred lines all hyperlinked in column A, I can
turn off each hyperlink individually by right clicking the mouse and a 'turn
off' facility being there , but I can't highlight all the hyperlinks and
turn them off in one action - it won't do it. Is it possible to turn all
off with one facility?

Many thanks
Paul B.

 

[Dave Peterson]

You could use a small macro to remove the hyperlinks from the current selection.

option explicit
sub testme()
selection.hyperlinks.delete
end sub

or you could just type the command that does the work into the immediate window
in the VBE:

hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)

type this and hit enter
selection.hyperlinks.delete