select the range with the links (the whole worksheet??)
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Azra wrote:

Please can anyone help me with this question

--

Dave Peterson