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

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

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.

"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

On 25 Sep, 10:11, Uma Nandan
wrote:

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.

If he was able to select cells containing unwanted hyperlink he could
just click "remove hyperlink", couldn't he?

The problem is to remove hyperlink in one go, out from cells which
contain it, no matter where those cells are and without necessary to
find them one by one

If hyperlinked cells exist in just one column or row then it's even
easier. Highlight the whole length and remove hyperlink. But I don't
think we are dealing with this situation in this case

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.


"Uma Nandan" wrote:

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.

"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

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