Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Hyperlink on Websites Addresses

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Learning Excel - 30 May 2008 14:17 GMT
This question has been asked in previous posts, but not specifically
responded to
WEBSITES.
Scenario : worksheet with Websites links pasted going from A1 to A300.
               Hyperlinks were edited and name changed>customized.
               Sorted alphabetically.
               Data Validation in C1, same worksheet.
Q : How can I choose from the DV a link that will go directly to the
     WEBSITE selected ? or jump to the link ?
THANKS.
Signature

Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

Dave Peterson - 30 May 2008 14:48 GMT
Did you use Insert|hyperlink type hyperlinks?

If yes,...

If you've sorted the data, you may find that the hyperlinks assigned to the cell
aren't what you need for the data in that cell.

I like to use the =hyperlink() function in an adjacent cell.  Then I can include
that column and do all the sorts I want and not lose the association.

So depending on what you have in the cell (not the hyperlink itself):
=hyperlink("http://" & a1, "Click me")

may work ok for you.

If you have lots of the insert|Hyperlinks type hyperlinks that you want to
delete, youc can do this:

Select the range to clean up (all the cells on that worksheet???)
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 go back to excel and see if it worked ok.

> This question has been asked in previous posts, but not specifically
> responded to
[quoted text clipped - 10 lines]
> I say : I don''''''''t even know, I don''''''''t
> know nothing.

Signature

Dave Peterson

Learning Excel - 30 May 2008 15:12 GMT
Thanks for you time Dave.
Is not working either way for me, and I think I did not explained right,
I'll try my best :
I use just one worksheet and is called websites.
Everytime I go to a website I'm interested, instead of saving it in MY
Favorites,
I copy the toolbar address and paste it in my worksheet, probably thats a
link, not a hyperlink, sorry.
Then I right click and do  edit hyperlink and give it a name EX: "discussion
group" for this one we are on.
Then I select A1 to A300 and SORT alphabetically.
Here comes  my invention :
I did data valitation  for those links, or hyperlinks who knows now, and
when I drop down I was expecting to get directly link to the website I
selected, but of course is not that easy. Now your turn... uff...tired.
Thanks.

Signature

Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

> Did you use Insert|hyperlink type hyperlinks?
>
[quoted text clipped - 36 lines]
> > I say : I don''''''''t even know, I don''''''''t
> > know nothing.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.