remove hyperlink from group of entries

[Raymond]

Hello All,

Is there a way to remove hyperlinks from a group of cells? I know you can
reight click on a cell that has text that links to anotehr documents or
website. But can you select an entire group of cells that are like that
(that have links to other sites) and remove the the hyperlinks at one time
instead of each cell individually?

Thanks for any information you can provide.

Raymond

 

[Jim Cone]

Raymond,
You can select the cells and go to: Edit (menu) | Clear | Contents
Every selected cell is cleared.
- or -
Try the Free Excel add-in "XL Extras" as it only removes hyperlinks;
the cell contents still remain.
It can also sort sheets and create a table of contents among other things.
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"Raymond"
<[email protected]>
wrote in message
Hello All,

Is there a way to remove hyperlinks from a group of cells? I know you can
reight click on a cell that has text that links to anotehr documents or
website. But can you select an entire group of cells that are like that
(that have links to other sites) and remove the the hyperlinks at one time
instead of each cell individually?

Thanks for any information you can provide.

Raymond

 

[Raymond]

Jim,

Thanks! That looks like what I need. Some other interesting software there
too!


Raymond

 

[Dave Peterson]

Select the range
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

 

[FrodeOlsen]

Select the range
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Have a look at the ASAP Utilities site as well, that package contain a
number of handy tools!

http://www.asap-utilities.com/



Frode