How to remove so many hyperlink in a single click?

[Harshad]

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

 

[muddan madhu]

try this

Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

 

[Uma Nandan]

Hi Harshad,

Try the following if its MS 2007.

- Select the cells for those you want to remove hyperlink.
- On the Home tab, in the Styles group, click Cell Styles
- Under Good, Bad, and Neutral, select Normal.

Hope it helps.

 

[Uma Nandan]

you can try this also:


- Select the cells for those you want to remove hyperlink.
1. In a blank cell, type the number 1.
2. Right-click the cell, and then click Copy on the shortcut menu.
3. Hold down CTRL and select the cells for those you want to remove hyperlink.
- On the Home tab, in the Clipboard group, click the arrow below Paste, and
then click Paste Special.
- Under Operation, click Multiply, and then click OK.
- On the Home tab, in the Styles group, click Cell Styles.
- Select Normal.

 

[Harshad]

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