How do I delete several hyperlinks in an Excel spreadsheet?
 

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

How do I delete several hyperlinks in an Excel spreadsheet?
 

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

How do I delete several hyperlinks in an Excel spreadsheet?
 

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

How do I delete several hyperlinks in an Excel spreadsheet?
 

I know this may seem silly, but where/how do I paste this statement into
Visual Basic? Do I replace "activesheet" with the name of the worksheet that
has the hyperlinks? Thanks!

"zz" wrote:

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

How do I delete several hyperlinks in an Excel spreadsheet?
 

select the range with the links (the whole worksheet??)
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

trainer07 wrote:

I know this may seem silly, but where/how do I paste this statement into
Visual Basic? Do I replace "activesheet" with the name of the worksheet that
has the hyperlinks? Thanks!

"zz" wrote:

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




--

Dave Peterson