Thread: Button/Hyperlink/Random Page

Ok so I am new here and was browsing the forums. I can usually always find what I need, but I have been messing with this for several hours and its driving me crazy.

What I want to do is have a button that when clicked will take you to a random page (hyperlink) inside the workbook.

This is where I am. I made a list of links I wanted to yield by clicking on the button. I used a random number generator to generate a number. Using this number I created an if statement to yield the randomized page as a link in a specified cell. I created a macro to allow the link to be clicked and added it to the button. I thought this would work the way I wanted, but I was wrong. Here is my problem the macro will not pick up on the link that is generated by the if statement. (not saying it won't I don't know how) I tried to fix this by not using if statement and putting a link in the cell and recording the macro. I got the button to work with a link and I got the if statement to yield what I want but I can not combine the two to make it work properly.I am certain I am overlooking something very simple that is why I am asking for help.

Also if there is another way to just add multiple hyperlinks (randomized) to one button that I do not know about that would be great as well. Thanks in advance for any help that can be offered.

Maybe some code like this?

Sub RandomHyperlink()
ActiveSheet.Hyperlinks(WorksheetFunction.RandBetween(1, ActiveSheet.Hyperlinks.Count)).Follow
End Sub