Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"seeing" hyperlinks in a worksheet
I have to edit a worksheet to add numerous lines. This is an inventory sheet
with many hyperlinks between finished products and the raw materials used to make them. I would like to be able to "see" the hyperlinks that are currently in place in order to be able to add the lines and then correctly reset the hyperlinks. Is there a way to do this? -- mamalhe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"seeing" hyperlinks in a worksheet
Run this small macro. It will hi-light all the hyperlinks on a worksheet:
Sub findhyper() Dim h As Hyperlink For Each h In ActiveSheet.Hyperlinks Range(h.Range.Address).Interior.ColorIndex = 6 Next End Sub -- Gary''s Student - gsnu201001 "mamalhe" wrote: I have to edit a worksheet to add numerous lines. This is an inventory sheet with many hyperlinks between finished products and the raw materials used to make them. I would like to be able to "see" the hyperlinks that are currently in place in order to be able to add the lines and then correctly reset the hyperlinks. Is there a way to do this? -- mamalhe |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"seeing" hyperlinks in a worksheet
On 4/9/2010 6:35 AM, mamalhe wrote:
I have to edit a worksheet to add numerous lines. This is an inventory sheet with many hyperlinks between finished products and the raw materials used to make them. I would like to be able to "see" the hyperlinks that are currently in place in order to be able to add the lines and then correctly reset the hyperlinks. Is there a way to do this? Aren't the hyperlinks already shown blue and underlined in your spreadsheet? Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"seeing" hyperlinks in a worksheet
Yes the links are highlighted but there are multiple item numbers on one
sheet linked to one raw item on another sheet. I have to add new items, with new raw material. They are added by size so they will have to be inserted. The hyperlinks attach to the cell and don't move when you insert lines. I need to know what is linked now so I can insert lines and then relink the item numbers to the correct raw material. I'm looking for a way to map the links so I can recreate them when I have finished adding the new lines. -- mamalhe "Billns" wrote: On 4/9/2010 6:35 AM, mamalhe wrote: I have to edit a worksheet to add numerous lines. This is an inventory sheet with many hyperlinks between finished products and the raw materials used to make them. I would like to be able to "see" the hyperlinks that are currently in place in order to be able to add the lines and then correctly reset the hyperlinks. Is there a way to do this? Aren't the hyperlinks already shown blue and underlined in your spreadsheet? Bill . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"_Fill" and "_Key1" is contained in the worksheet I want to copy.. | Excel Discussion (Misc queries) | |||
Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |