A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Link from Autoshape keeps changing



 
 
Thread Tools Display Modes
  #1  
Old September 3rd, 2007, 05:08 AM posted to microsoft.public.excel.links
John Calder
external usenet poster
 
Posts: 192
Default Link from Autoshape keeps changing

Hi

I run Win2k and Excel 2K

I have an autoshape that when slected hyperlinks to a html file. The problem
I am having is that each time I open the file the hyperlink changes to one of
my other "recent files" hyperlink. To overcome it I have to selct the
autoshape then select Edit Hyperlink then select the one that I want from the
list of recenlty used hyperlinks. It used to hold the link ok but for some
reason it changes everytime I open the workbook now.

Does anyone know how I can get the hyperlink to stay with the sutoshape and
not change all the time?

Thanks

JOhn
  #2  
Old September 3rd, 2007, 12:36 PM posted to microsoft.public.excel.links
Gary''s Student
external usenet poster
 
Posts: 7,584
Default Link from Autoshape keeps changing

When creating the hyperlink, enclose the link address in double quotes, for
example:

"C:\Documents and Settings\Owner\My Documents\Mike\Hyper
Text\contact_list.html"
--
Gary''s Student - gsnu200742


"John Calder" wrote:

Hi

I run Win2k and Excel 2K

I have an autoshape that when slected hyperlinks to a html file. The problem
I am having is that each time I open the file the hyperlink changes to one of
my other "recent files" hyperlink. To overcome it I have to selct the
autoshape then select Edit Hyperlink then select the one that I want from the
list of recenlty used hyperlinks. It used to hold the link ok but for some
reason it changes everytime I open the workbook now.

Does anyone know how I can get the hyperlink to stay with the sutoshape and
not change all the time?

Thanks

JOhn

  #3  
Old September 3rd, 2007, 11:30 PM posted to microsoft.public.excel.links
John Calder
external usenet poster
 
Posts: 192
Default Link from Autoshape keeps changing

Thanks for your prompt reply. I did as you said but the hyperlink will not
work when I add the double quotes? The link I am using is as follows:

\\STLWOLSVR01\AMM\18Apps\CSA_Intranet\Data\Supply_ Chain\daily_reports\pctnstk.html

This link work fine, it;s just that it does not stay as the default link for
the autoshape.

Thanks again


"Gary''s Student" wrote:

When creating the hyperlink, enclose the link address in double quotes, for
example:

"C:\Documents and Settings\Owner\My Documents\Mike\Hyper
Text\contact_list.html"
--
Gary''s Student - gsnu200742


"John Calder" wrote:

Hi

I run Win2k and Excel 2K

I have an autoshape that when slected hyperlinks to a html file. The problem
I am having is that each time I open the file the hyperlink changes to one of
my other "recent files" hyperlink. To overcome it I have to selct the
autoshape then select Edit Hyperlink then select the one that I want from the
list of recenlty used hyperlinks. It used to hold the link ok but for some
reason it changes everytime I open the workbook now.

Does anyone know how I can get the hyperlink to stay with the sutoshape and
not change all the time?

Thanks

JOhn

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.