creating new shape and opening hyperlink dialog

[jjnelson81]

I have been scouring the forums for an answer to this one.... it is possible that I am not thinking about the approach in the right way.

I have some code that is copying a set of template tabs (hidden in the workbook) and creating copies. In the code, I create a shape on a dashboard sheet. Ultimately, I want that shape to act as a button to the first tab in the newly created series of tabs.

My thought process was to simply have the hyperlink dialog open up and have the user select the new tab to navigate to.

I have seen examples of opening the hyperlink dialog box, but it only creates a link and does not associate it with the shape that was just created.

Any guidance is appreciated!

 

[Colo]

Hi jjnelson81,

Hyperlink dialog can be opened as follows.

On Error Resume Next
Application.Dialogs(xlDialogInsertHyperlink).Show

To let user to select hyperlink destination, after selecting the copied shape, open the dialogue. Avoiding an error, "On Error Resume Next" is necessary.