remove hyperlinks Excel 2003

D

Dave Peterson

select your range to clean
alt-f11 (to see the VBE)
ctrl-g (to see the immediate window)

type this and hit enter
selection.hyperlinks.delete

And then close this window and go back to excel.
 
M

MarvInBoise

You also just put that code in a module and run it from a button anytime you
want.
 
Top