How do you break selected hyperlinks in Excel?

G

Guest

Hi, I'm trying to break a group of hyperlinks in a selected area in excel,
using vista. Also I've noticed that it seems impossible to do the same in
word. Does anyone know the secert, cause otherwise I'm doomed to do them
individually.
 
D

Dave Peterson

Does Break mean remove the hyperlinks?

Were the hyperlinks added via Insert|Hyperlink (xl2003 menu)

If yes to both, you could try:
Select the range that should have the hyperlinks removed
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then back to excel to check.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADRMS Breaks Excel Hyperlinks (when read only) 1
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! 1
Hyperlinks in cells in a protected worksheet not working 5
How do I get hyperlinks created in Excel to work in a PDF? 3
deleting lots of hyperlinks in Excel 2007 5
Hyperlinks changed by Excel again! 5
How do I unselect a cell in Excel? 2
How do I break a hyperlink in an Excel document? 3

Top