VBA to edit links

[tkaplan]

I have a workbook that I want the user to be required to change the
source file for a link every time they open the workbook.

What would my code be to just open edit/links menu option and then let
the user continue from there?

Thanks in advance.

 

[Jim Rech]

CommandBars("Edit").Controls("Links...").Execute

--
Jim
message |
| I have a workbook that I want the user to be required to change the
| source file for a link every time they open the workbook.
|
| What would my code be to just open edit/links menu option and then let
| the user continue from there?
|
| Thanks in advance.
|
|
| --
| tkaplan
| ------------------------------------------------------------------------
| tkaplan's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=22987
| View this thread: http://www.excelforum.com/showthread.php?threadid=387173
|