It worked!!! thanks you so much. Could you please tell me which training I
would need todo to know all this (I've got my MOS master already)? THANKS

"Sarah_Lecturer" wrote:

Hope this helps:

Select all the cells
hit alt-f11 (to get to the VBE, where macros live)
hit ctrl-g (to see the immediate window)

type this and hit enter:

selection.hyperlinks.delete

Close the VBE and back to excel to see if it worked.


"Pascale" wrote:

Hello
I work with Excel 2000. I have a spreadsheet with a lot of hyperlinks that I
would like to remove in one go if possible. I have tried selecting the link
and copy, paste special, value (ie not format) but it does not work. Any
suggestion?
Many thanks
Pascale