Hi Greg,

Perhaps:

Application.Dialogs(xlDialogInsertHyperlink).Show


---
Regards,
Norman



"Greg B" wrote in message
...
Is there a way for a macro to insert a hyperlink and then ask the user for
the location and the name to be chosen by the user.

Thanks in advance

Greg