Add Button to Start Hyperlink Wizard in Cell

[stvlange]

Hey All,

I'm putting together a form in excel and have an area where I want to add a button say in Cell A1 that when clicked will start the Hyperlink Wizard with it looking at the root of "G:\" and am having a hell of a time finding either macro code or the VBA code to do this.

Basically I had a second in this form where people are supposed to list critical files required for the process the form details. I'd like to give them an easy way to display these critical files with the full path to where they live.

Hyperlink seems like the perfect solution, but I need to drastically simplify the process for my users. Clicking a button is something I think they can do.

Any help is more than appreciated, I've had a hell of a time finding an answer to this. Thanks in advance.

-Steve

 

[stvlange]

Found an answer..

Sub HL_183()
Range("O183").Select
Application.Dialogs(xlDialogInsertHyperlink).Show
End Sub

Works like a charm. I'd like it to start the Lookin: at a specific drive but this is better than nothing.