Removing Hyperlinks from a worksheet

[pickslides]

Hi there all.

I have copied then pasted some stats from the web onto a new worksheet.

On the web some of the stats were also hyperlinks so now when I click on a cell it opens firefox. Is there a way of disabling the hyperlinks on my sheet?

Hope this makes sense?

[stanleydgromjr]

pickslides,

See:
How do I disable hyperlinks in Excel?
http://www.pcreview.co.uk/forums/thread-2036849.php

[martindwilson]

either put this in a new module

Please Login or Register  to view this content.

and run from tools macros
or paste

Please Login or Register  to view this content.

into the imediate window and hit return (alt +f11 then ctrl+g to view immediate window)