Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink created with a macro, altered on save.
I have a workbook (Workbook1) that contains a macro. When the macro is run it
creates a hyperlink on one of the worksheets to another workbook(workbook2). The hyperlink works fine until I click the save button to save the workbook1. It then changes the hyperlink path and it no longer links to workbook2. What is really confusing is that this only happens on a certain computer. When its tested on other computers on the network it works no problem and anybody can link to Workbook2 from Workbook1 hyperlink except for hyperlinks created by the one computer. Any idea what the issue is? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink created with a macro, altered on save.
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) I like to use the =hyperlink() worksheet function. It has never failed me this way: =hyperlink("file:////yourpathtothe\workbook.xls","Click me") Dan wrote: I have a workbook (Workbook1) that contains a macro. When the macro is run it creates a hyperlink on one of the worksheets to another workbook(workbook2). The hyperlink works fine until I click the save button to save the workbook1. It then changes the hyperlink path and it no longer links to workbook2. What is really confusing is that this only happens on a certain computer. When its tested on other computers on the network it works no problem and anybody can link to Workbook2 from Workbook1 hyperlink except for hyperlinks created by the one computer. Any idea what the issue is? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I create a save file hyperlink or macro in a workbook? | Excel Programming | |||
Why can I open only the last pdf file hyperlink created? | Excel Worksheet Functions | |||
can not save altered files over network | Excel Discussion (Misc queries) | |||
Save, Save As, Print Grayed Out when instance created via VBA/VB6 | Excel Programming | |||
Save, Save As, Print Grayed Out when instance created via VBA/VB6 | Excel Programming |