ExcelBanter - Edit Links

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Edit Links (https://www.excelbanter.com/excel-programming/306235-edit-links.html)

Russell Harris[_2_]

Edit Links

I can't find out how to invoke the Edit Links Dialogue box from with a macro
?

Anyone able to help ?

Tom Ogilvy

Edit Links

Sub showLink()
res = Application.Dialogs(xlDialogOpenLinks).Show
End Sub

Of course you need to have links in the workbook.

--
Regards,
Tom Ogilvy

"Russell Harris" wrote in message
...
I can't find out how to invoke the Edit Links Dialogue box from with a
macro
?

Anyone able to help ?

All times are GMT +1. The time now is 02:58 AM.