VBA to run Hyperlinks

[DownUnderFar]

Hi All:

I have a workbook with the sheets "Buttons," "Weekdays," and "Weekends."

The sheets "Weekdays" and "Weekends" has hyperlinks in Column G.
The sheet "Buttons" has two buttons, named "Weekdays" and "Weekends."

I'm looking for a code that when I click the button "Weekdays," it will run all of the hyperlinks in sheet "Weekdays".
Same for the weekends.

Note - there are no other hyperlinks on either sheet than those that I want to run, so a macro that runs all hyperlinks on a sheet will work. There is, however, other data on the sheets.

Also, I'm unable to upload a mini-sheet at the moment. I'll try to upload one later tonight if anyone needs one.

 

[frabulator]

You can do something like this.

Sub test()
    Dim URL As String
    URL = "https:\\www.google.com"
    
    
    ActiveWorkbook.FollowHyperlink _
    Address:=URL, _
    NewWindow:=True, _
    AddHistory:=True
    
    
End Sub

 

[DownUnderFar]

OK, so how do I reference the links on on Sheet "Weekdays" in column G into this?

 

[frabulator]

OK, so how do I reference the links on on Sheet "Weekdays" in column G into this?

URL = Worksheets("Weekdays").Range("G1").Value