Hyperlink Removal

Deactivate several hyperlinks at once:

Type the number 1 in a blank cell, and right-click the cell.

Click Copy on the shortcut menu.

While pressing CTRL, select each hyperlink you want to deactivate.

(To select a cell that has a hyperlink in it without jumping to the
hyperlink destination, click the cell and hold the mouse button until
the cursor becomes a cross , then release the mouse button.)

Click Paste Special on the Edit menu.

Under Operation, click Multiply and then click OK.




"Andy Brown" wrote in message ...
Or this

CTRL-A ; copy ; paste ; ESC.

Rgds,
Andy

I didn't see the original post but if you want to remove all the links on a
sheet.....

Sub SeeYaLinks()
ActiveSheet.Hyperlinks.Delete
End Sub

...or you can tweak for only selected cells or however you like.

Dennis

==========


In article ,
(Doug) wrote:
Deactivate several hyperlinks at once:

Type the number 1 in a blank cell, and right-click the cell.

Click Copy on the shortcut menu.

While pressing CTRL, select each hyperlink you want to deactivate.

(To select a cell that has a hyperlink in it without jumping to the
hyperlink destination, click the cell and hold the mouse button until
the cursor becomes a cross , then release the mouse button.)

Click Paste Special on the Edit menu.

Under Operation, click Multiply and then click OK.




"Andy Brown" wrote in message
...
Or this

CTRL-A ; copy ; paste ; ESC.

Rgds,
Andy