Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2008, 02:51 PM
alicein1derville alicein1derville is offline
Banned
Creating Hyperlinks
 
Join Date: Dec 2008
Posts: 1
alicein1derville is on a distinguished road
Default Creating Hyperlinks

Can you format cells to automatically create hyperlinks? If so, how?
Reply With Quote
  #2  
Old 12-08-2008, 03:53 PM
caholmes caholmes is offline Creating Hyperlinks Windows Vista Creating Hyperlinks Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default Automatic Hyperlinks

A hyperlink is not a format. You will need to create a macro (VBA) to automate this process
Reply With Quote
  #3  
Old 12-08-2008, 06:15 PM
Matrix's Avatar
Matrix Matrix is offline Creating Hyperlinks Windows 10 Creating Hyperlinks Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
Matrix is on a distinguished road
Default

If the content of a cell is an URL such as https://www.msofficeforums.com/, Excel will make it clickable by default.
Reply With Quote
  #4  
Old 12-10-2008, 11:27 AM
turnbuk turnbuk is offline Creating Hyperlinks Windows XP Creating Hyperlinks Office 2003
Novice
 
Join Date: Dec 2008
Posts: 6
turnbuk is on a distinguished road
Default

You can format a cell in ACCESS to automatically create a hyperlink from any text you type in...but you'll still have to adjust the address of the link.
Reply With Quote
  #5  
Old 12-12-2008, 06:34 AM
Emily Emily is offline
Novice
 
Join Date: Dec 2008
Location: Hong Kong
Posts: 7
Emily is on a distinguished road
Default

Excel function Hyperlink but not automatically create link

HYPERLINK(link_location,friendly_name)
Reply With Quote
  #6  
Old 02-08-2009, 10:31 PM
Gary Winnick Gary Winnick is offline
Novice
 
Join Date: Feb 2009
Posts: 1
Gary Winnick is on a distinguished road
Default

Hyperlink is very easy.
Select the column In upper toolbar globe type icon click on it and put url on it. You column will be hyper.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook hyperlinks don't work. russia5 Office 1 05-21-2009 02:20 PM
Word to Excel hyperlinks and spaces gak Word 1 09-14-2008 08:38 AM
hyperlinks from copying in web browser are long format... BERKEY Word 0 12-14-2007 10:33 AM
Hyperlinks dont work iturnrocks Outlook 0 11-21-2006 10:19 AM
Creating new project Using PDS myanilkumar Project 0 01-05-2006 12:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft