Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Hyperlink On Single Word In A Cell?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi all, just wondering is it possible to insert a hyperlink on a single word in a cell containing text, rather than on the whole cell? Or to have more than one hyperlink in the cell, each referring to a single word? My initial research says no, but I would be delighted if somebody could prove me wrong.

Thanks.

View Answers     

Similar Excel Tutorials

Excel Prank - Automatically Change User-Entered Text
Use AutoCorrect to change the text a user enters into something funny. This is a great little prank to use on co-wo ...
Determine if Cells Contain a Specific Value in Excel
Find if a cell or range of cells contains a specific value in Excel. This method can be used on individual cells wh ...
Link to a Location Within the Spreadsheet in Excel
How to make clickable links within Excel that point to other locations within the same spreadsheet. This allows yo ...
Count the Number of Cells that Contain Specific Text in Excel
How to count the number of cells that contain specific text within a spreadsheet in Excel. I'll show you how to cou ...

Helpful Excel Macros

Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter
- Extract whole words from a cell or sentence in Excel with this UDF. This allows you to specify which word from a cell y
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
- This free Excel UDF (user defined function) returns the first word from a cell in Excel. This extracts the first word f
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Capitalize the First Letter of Every Word in a Cell
- This macro will make the text of any selected cell in excel proper case. This means that the first letter of any word in

Similar Topics







I have a database set up in Excel where I can click on a cell and it opens a Word file. The cell is just a hyperlink to a network drive where the Word file is stored.

When I click on the hyperlink, Excel is minimized and Word (containing my file) is brought up. When I close Word, Excel stays minimized. I'm using two monitors, one to look at the Excel file and one to look at the Word files, and when I look at more than one file it because a click-fest to keep Excel up.

Is there a way to keep Excel from minimizing when I open a hyperlink?

Thanks!


Hi,

I need to create a hyperlink which takes me from a cell in excel to a bookmark in a word doc which will be inserted into the excel file itself. The problem i have is that the users of the spreadsheet will not have access to a shared server (so i can't do a regular hyperlink), but will have to reference specific parts of the word doc at a click of a button.

I've been able to open the file using a macro, but not get to the bookmarks in the word doc.

Please ask if further clarification of my problem is needed.


I use excel '08 for Mac, and would like to hyperlink a word/phrase to a specific word or pdf document on my computer.

Here's what I do: right-click the word/phrase in the cell, click "hyperlink," and select "document" then click "ok"

Here's what happens: although the word then appears hyperlinked, when I click on it I get the message "cannot open that specific file".

Any suggestions? Thanks in advance, Nate


How can I hyperlink from word to a particular cell in an Excel spreadsheet. I have tried naming the cell, but I cant find the function on the toolbar to allow it then to be linked. I am assuming its like making a bookmark in a word doc.
THanks for your help


I thought this would be pretty straight forward but I guess I was wrong. I
want to create a hyperlink to a web site within a cell. But, I have a large
amount of text in the cell and I don't want the whole cell hyperlinked - just
the one word.

Can this be done?



Hi Folks,

Is it possible to create a macro or code for the following issue?

In column B I have a list of names (which could build to 500) that I aim to hyperlink each to their own word doc file. When adding a new name, can a macro run to check down the list to see if a hyperlink is made, if not add the link to a word doc using the same title as the cell in another folder. Thus it has to create the word file before it can be linked?

I have a button that will put the names in alpha order.

Cheers
Marty


How do you make a macro that does the following: go to next cell down in Column B copy contents (a single word) of that cell select entire Column A find first instance, in Column A, of the word that was copied from Column B, above, (the word is part of a sentence in a single cell in Column A), underline just that word (not the whole sentence) in Column A loop


I hope someone can help - this is above my skills.

I have a column in excel with the word Yes, No, or Check. I would like that word to show up as a hyperlink to a cell in a different worksheet based on a value in the first sheet.

For instance

Sheet 1:
Tomato YES
Carrot NO


Sheet 2:
carrot
Tomato

The word yes should show as a hyperlink which directs to the cell in sheet 2 named Carrot. The word NO (cell b2) should direct to carrot in worksheet 2 (cell a1) based on the fact that that word is also contained in sheet 1 cell A2.

HELP?

Thanks in advance


Hi
Can someone please help me..

Heres what I want to do.

Whilst in Excel create a hyperlink to a specific docoument in Word (Thats the easy part) once Ive finished with the Word document either a button with a macro or hyperlink back to my excel sheet and closing the word document.

Many Thanks

Shaun


Can this be done? This is what I want to do. Say I have a workbook open and my A column cells are filled with (example) Mike-1 in the first row Mike-2 in the second row and so on. Now I have another folder on the computer with Word documents that I want to hyperlink to. The corresponding Word file is named mike1. So I want Excel to go through column A and Hyperlink to the corresponding Word file. Is it possible to do this?


Ok,

I have a bunch of tabs. Each tab has a name like "WO-101", "WO-102", etc..

The names are on a datasheet that is automated from a main sheet thanks to Akashwani......

I have a Table of contents page that pulls from the datasheet using just this formula:

=IF(StoreData!A2="","",StoreData!A2)

That way if the cell = "WO-101" then the cell on the Table of contents page = "WO-101"

Now the datasheet creates a copy of the "WO-101" sheet and names that sheet tab "WO-101"

What i need from the hyperlink guru that responds to this is a maco or formula that will change the word "WO-101' to a hyperlink automaticlly and direct that link to the copied page named "WO-101".


In short, I need each word that pops up in my column to hyperlink to the sheet that matches it's name. So I can click on the word and go directly to the applicable sheet. Keep in mind the cell where the word pops up is set to a formula {=IF(StoreData!A2="","",StoreData!A2)}

Any takers?


hi guys, is it possible to make a hyperlink in say cell 1A to link to page 3 in a word document? ive tried creating a macro but to no joy.
thanks


I have a spreedsheet with Company Data in it that I need to extract emails from.

The data for each company is in a row however the Emails are all set as a hyperlink with this data in various columns through out the sheet.

E.G. Row 1 has the word Email in column N with the word email being a hyperlink, row 2 has the word email in Column L, row 3 has the word email in Column M.

I need to search through each row in the sheet and find the word email, extract the email address from the hyperlink and cut/paste the email into one specific column at the end while keeping it in the same row. I also have the word website as a hyperlink that I need to extract the URL from and paste into a separate column next to the column with email addresses.

Any Help?


I am trying to build a hyperlink useing various cells. Currently the formula looks like this

Quote:

=(L2&H10&L3&K14&L4&C1&L5&C1&L6&C4&L9)

The results of the formula can be displayed as text but as soon as I add "=HYPERLINK" it errors. Is there another method I can use to get this to run?

I was able to find a workaround regarding copying the hyperlink pasting it into word then pasting it into excel which allowed the hyperlink to exceed 255ch. When I modify the cell to the original formula the URL does not update and keeps going to that original page.


I have a hyperlink to a word document, but I really don't want to open up word, as much as I just want that link to bring up a window with the TEXT found in the word document. In essence, I want a pop-up window, so you can still see excel in the background.

I tried placing the following code in the word document, but it just opened it normally without the size changes:

Code:

Private Sub Document_Open()
     
    With Application
        .Width = 150
        .Height = 500
    End With
     
End Sub







Hi folks,

This is actually a Word macro, but I guess the VBA principle is the same. This is what I have - it counts all highlighted words in a document:



Please Login or Register  to view this content.


The thing is that instead of counting hyperlinks (entered as text) as a SINGLE word, like standard wordcount in the MS Word does, it counts every item in the hyperlink. So for example, HTML Code: 

bbc.co.uk


would be counted as 5 words.

(it also counts this "pears/apples" as three words, instead of two but that's not so much of an issue).

Basically, is there a way to tell the Macro to count hyperlinks (underlined words) as a SINGLE word?

Any help is appreciated.



If e.g. a cell has the function =+HYPERLINK("http://www.excelforum.com";"Excel Forum"), I want to copy this cell to an other cell which has only the name "Excel Forum", which act as usaully, that means click on the name will move you to that hyperlink.

I did a lot of reading for a solution by means of Google and found only one, the same as I found allready myself:
- Copy the original cell and paste it in a Word document. There you find the hyperlink form as I want. Then copy this hyperlink back to Excell and ready.

But that must be possible without using Word as immediate. But How?

Kind reagrds

Jan Lichtenbelt

Hey all,

I'm trying to use a simple macro to check whether the font color in a cell is red, and if so, to execute the hyperlink in that cell.

That hyperlink, in turn, opens a word macro, which has an "execute on open" macro within it. I've set my word macro security to low, so that it doesn't ask me every time if I want to open the macro.

When I just click the hyperlink in excel, I have no problems at all. When I run through the macro step by step in the vba editor, I have no problem.

But when I try to run the macro as a whole, I get the "some macros are dangerous, do you want to open this file" error after the first one goes through.

The problem here is obviously I want to AVOID human interaction with the file - I want it all to execute automatically once the macro (in excel) has been started.

I've double checked my word security settings (low) - here's the code I'm using in excel:

Range("M7").Select
For x = 1 To 3
If Selection.Font.ColorIndex = 3 Then
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=False
Else
End If
ActiveCell.Offset(1, 0).Select
Next x


(I'll admit that since I don't know squat about VBA, I just used the macro recorder to get the execution of the hyperlink).

Any help would be MUCH appreciated!!


Hi all,

This is my first post so please correct me if I am doing it wrong. I have read your forum so many times with GREAT success and now for the first time I can't seem to find the exact answer I am looking for. So, I am jumping into the world of forum help.

What I am trying to do is probably pretty simple. I have an excel sheet with a number of rows (about 100) where each row has a hyperlink. I am trying to run through the rows and for each hyperlink return the last modified date of the linked file, next to the hyperlink. All the files linked to are word documents.

The below picture is a screenshot from my file. The hyperlinks are in column D and I would like the date pasted in column E.

Thanks a lot for your help! This time, but also all the others


Example.jpg

Best, Aja

I'm having trouble posting hyperlink inside an individual cell. I need to highlight some of the text within a cell and create a hyperlink to another folder. However, when i try to insert a hyperlink, the entire cell content is selected and becomes the link (not just the few lines of text i would like).

does anyone have a solution?

many thanks




Hi,

I have two questions.
1 Can I copy and paste chart or range of excel cells in to word document, which automatically keeps updating from excel source?

2 Secondly, how can I link that word document to a particular name in cell , where when I double click , it opens specified word document? I can not hyperlink it as the name or value in cells may change and hyperlink may be lost. It will need a VBA

I have attached the sample

Thanks

Just two hours ago, I could right click a cell, and I would be given a menu of options - the last of which was one entitled 'hyperlink.' I would click on this and I would be given a pop-up window enabling me to type in a website address and some text for the hyperlink.

For some reason something has changed and now 'hyperlink' is the only option that's non-clickable. And if I press try to do "insert->hyperlink" the hyperlink button is not clickable either.

What the hell is going on ??

Thanks so much.


Just two hours ago, I could right click a cell, and I would be given a menu of options - the last of which was one entitled 'hyperlink.' I would click on this and I would be given a pop-up window enabling me to type in a website address and some text for the hyperlink.

For some reason something has changed and now 'hyperlink' is the only option that's non-clickable. And if I press try to do "insert->hyperlink" the hyperlink button is not clickable either.

Does anybody know what might be the problem ??

Thanks so much.


Sir,

I am using excel 2003

I would like to get word bookmarked data into excel cell.

for this i used the formula

=Word.Document.8|'C:\\My Documents\\hai.doc'!'!OLE_LINK1'

where C:\\My Documents\\hai.doc is my word file
OLE_LINK1 is my book mark name.

It is working good for single line bookmarks.

If i enter multiple lines in that bookmarks it only gets the single.

what can i do.. ??

Please help me..


Hi All,

I have the following HYPERLINK Function in a cell:

Annual certification

* C 42 Go to International Shares Input
Spreadsheet Formulas Cell Formula C42 =HYPERLINK(IntSharesPropn,"Go to International Shares Input")

Excel tables to the web >> Excel Jeanie HTML 4

Here IntSharesPropn is a global named range - a single cell, which I would like to direct the user to, by clicking this hyperlink cell.

Everytime I click on the the HYPERLINK, it pops up with the error message "Cannot Open the specified file".

Could anyone please explain how to amend the formula?

regards