| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit=Links dialog box-use code to display
I have a button that when pressed calls a subroutine. The sub unprotects two
worksheets, displays the Edit=Links dialog box, then the user changes the existing link (an Excel file) to a new link (an Excel file) and updates. Then, the macro protects the two worksheets again and exits. What is the code to show the Edit=Links dialog box? I am using the following code to display the dialog box. I can get it to work with many other dialog boxes, but the Edit=Links won't work. Application.Dialogs(xlDialogPrint).Show Thanks, Robert -- Robert Engle Brinker International, Inc. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Edit=Links dialog box-use code to display
Application.Dialogs(xlDialogOpenLinks).Show
Robert wrote: I have a button that when pressed calls a subroutine. The sub unprotects two worksheets, displays the Edit=Links dialog box, then the user changes the existing link (an Excel file) to a new link (an Excel file) and updates. Then, the macro protects the two worksheets again and exits. What is the code to show the Edit=Links dialog box? I am using the following code to display the dialog box. I can get it to work with many other dialog boxes, but the Edit=Links won't work. Application.Dialogs(xlDialogPrint).Show Thanks, Robert -- Robert Engle Brinker International, Inc. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Edit=Links dialog box-use code to display
Perfect. Thanks!
-- Robert Engle Brinker International, Inc. "Dave Peterson" wrote: Application.Dialogs(xlDialogOpenLinks).Show Robert wrote: I have a button that when pressed calls a subroutine. The sub unprotects two worksheets, displays the Edit=Links dialog box, then the user changes the existing link (an Excel file) to a new link (an Excel file) and updates. Then, the macro protects the two worksheets again and exits. What is the code to show the Edit=Links dialog box? I am using the following code to display the dialog box. I can get it to work with many other dialog boxes, but the Edit=Links won't work. Application.Dialogs(xlDialogPrint).Show Thanks, Robert -- Robert Engle Brinker International, Inc. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit Links Dialog Box too long to view contents | Links and Linking in Excel | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| Hardcode Links - edit my code please? | Excel Programming | |||
| display edit | fill series dialog box | Excel Programming | |||
| Code to display dialog for unhiding sheets | Excel Programming | |||
Linear Mode
