Dear Madhu,

Thank you.
After posting quary, i found one macro in http://spreadsheetpage.com/, which
also works very nice.

Sub ()
Cells.Hyperlinks.Delet
End Sub

Thank you again,
harshad
"muddan madhu" wrote:

try this

Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub


On Sep 25, 12:27 pm, Harshad wrote:
I have so may cells in a sheet, which cointains hyperlink. i want to remove
hyperlink off all the cells of sheet in a single clik.

Extraordinary ideas wanted.

Thanks