VBA to edit links
 

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

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

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