Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you break selected hyperlinks in Excel?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you break selected hyperlinks in Excel?
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. sangefish wrote: 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you break selected hyperlinks in Excel?
ps. You may want to try an MSWord newsgroup for your other question.
sangefish wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks work once, then break | Excel Discussion (Misc queries) | |||
How do I put in a page break after every selected row. | Excel Discussion (Misc queries) | |||
Hyperlinks break when synching from Pocket Excel | Links and Linking in Excel | |||
Hyperlinks break the preview of a cell | Excel Discussion (Misc queries) | |||
Hyperlinks "break" | Links and Linking in Excel |