Macro question?

[gawd89108]

I am new at Excel and of course macro's. I have placed a button on my worksheet in which I want it to direct the user to my G:/ drive when clicked. I am not good at writing macro's yet and it's giving me a head ache.... Thanks in advance.

 

[Blade Hunter]

You don't need a button you can use a hyperlink.

Put the text in a cell then highlight that cell and press CTRL-K

Browse to your G drive in the box that comes up and click OK.

Clicking the text in that cell will open the G drive.

 

[gawd89108]

Thanks, but I would like to use the button feature as I have several other buttons on the sheet doing different things. Is it possible to have a macro hyperlink to my drive?

 

[gawd89108]

Someone help, I am nearly complete with my workbook

 

[John Davis]

Someone help, I am nearly complete with my workbook

Maybe:

ChDir "G:\whatever folder"

 

[Norie]

Try this.

Option Explicit
 
Sub Button1_Click()
    ThisWorkbook.FollowHyperlink "file:\\G:\"
End Sub

Note if G:\ is a mapped drive you might need to use the UNC path rather than just G:\.

 

[gawd89108]

Try this.

Option Explicit
 
Sub Button1_Click()
    ThisWorkbook.FollowHyperlink "file:\\G:\"
End Sub

Note if G:\ is a mapped drive you might need to use the UNC path rather than just G:\.

How do I go about using the UNC path because the other code did not work. Thanks for the help by the way.

 

[gawd89108]

Figured it out!!!! Thanks a million homie.....
If your ever in VEGAS hit me up and I'll show you the time of your life