Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing the source of a link | Excel Discussion (Misc queries) | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
Automatically changing link. How? | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Changing Worksheet Name in Link | Excel Worksheet Functions |