a faster option

in vba

"activesheet.hyperlinks.delete"


--
---
zz [MX]
cuasi-musico,semi-poeta y loco


"s31064" wrote in message
...
Used to drive me nuts too. I found this in the Excel help files:

1. Type the number 1 in a blank cell, and right-click the cell.
2. Click Copy on the shortcut menu.
3. While pressing CTRL, select each hyperlink (hyperlink: Colored and
underlined text or a graphic that you click to go to a file, a location in
a
file, a Web page on the World Wide Web, or a Web page on an intranet.
Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP
sites.)
you want to deactivate.
4. Click Paste Special on the Edit menu.
5. Under Operation, click Multiply and then click OK.

"trainer07" wrote:

Some of my technicians have hyperlinks embedded in their excel
spreadsheets
that they can't see. We know they are there when they pass the mouse
over
the cell it gives them a "hand" with the name of the link. This is
causing
the file size to be very large. How do we remove the invisible
hyperlinks
and stop them from happening in the future