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
"tkaplan" <[email protected]> wrote in
message news:[email protected]...
|
| 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...o&userid=22987
| View this thread: http://www.excelforum.com/showthread...hreadid=387173
|