| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit Links: make update manual | Excel Discussion (Misc queries) | |||
| Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
| Edit Links in excel....Urgnet.. | Excel Discussion (Misc queries) | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
| edit links | Excel Worksheet Functions | |||
Linear Mode
