Hyperlinks with hidden sheets

Hello all, I am working with a file that i have multiple sheets. I have code that is written to automatically hid the sheets except the Index. I have hyperlinks that go to the various sheets but I am also trying to have hyperlinks to go to a website. When clicking on the hyperlinks for the website, I get a error as follows:

Run-time error '9':
Subscript out of range.

Here is the code I am using to hid and activate the sheets when the hyperlink is selected. PLEASE HELP!

Please Login or Register  to view this content.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic