Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 202
Default locking hyperlinks address

I am creating hyperlinks by the simple method of right clicking on a cell and
inserting a hyperlink.

When I email my document that contains hyperlinks, the location changes and
my hyperlinks do not work.

is my solution....
in the hyperlink creation dialog box, do I add " to the beginning and end of
the address in the address box at the bottom of the dialog box?
thank you in advance, Jane
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default locking hyperlinks address

Maybe you could drop the Insert|Hyperlink style of hyperlinks and replace them
with by using the =hyperlink() worksheet function.

======
I'm not sure if this will work with your hyperlinks, but a few people have said
that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

Jane wrote:

I am creating hyperlinks by the simple method of right clicking on a cell and
inserting a hyperlink.

When I email my document that contains hyperlinks, the location changes and
my hyperlinks do not work.

is my solution....
in the hyperlink creation dialog box, do I add " to the beginning and end of
the address in the address box at the bottom of the dialog box?
thank you in advance, Jane


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with hyperlinks in pulldown list. Anyone know how? Wayne Knazek Excel Discussion (Misc queries) 0 June 26th 06 04:29 PM
Still need help with hyperlinks in pulldown list. Anyone know how Wayne Knazek Excel Discussion (Misc queries) 0 June 26th 06 03:40 PM
Relative Hyperlinks to local files CR Optiker Links and Linking in Excel 3 April 5th 06 06:05 AM
Master Worksheet populated by other Worksheets? Steve Lundwall Excel Worksheet Functions 0 March 3rd 06 01:38 PM
hyperlinks in different drives cdroot4383 Excel Discussion (Misc queries) 2 January 5th 06 07:35 PM


All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"