Hi,

I'm trying to create a command button (on click event) that will open the Links (Edit Menu) 'dialog' box. (So a user can update their Excel Workbook links from what mine says to where they put them, if necessary).


Any help appreciated.

Cheers

Stuart

Hello Stuart, the following works for me in '00:

On Error Resume Next
Application.CommandBars.FindControl(ID:=759).Execute

I include the error handler in the event the file has no external links. Good hunting eh.

Absolutely Fabulous!!!!


Thanks very much Nate, worked first time.


Regards,

Stuart

------------------------


Well, what if there is no tomorrow? There wasn't one today.
- Phil Connors, 'Groundhog Day'

Whew, glad to hear it!

You are welcome.