FollowHyperlink Event Macro

[webfeet2]

Hello,

In my excel file, I have a series of hyperlinks on the first worksheet that link to the rest of the worksheets in the workbook. I want to hide these worksheets and only have them open when somone clicks on the hyperlink.

To do this, I have been trying to write a macro for the FollowHyperlink event so that when somebody clicks on the hyperlink the excel sheet is made visible. The following code works:

Sheets("sheetX").Visible = True
Sheets("sheetX").Select

However, I do not know how to write the code so that only the worksheet that corresponds to the hyperlink is the one that is made visible.

Any help or tips would be greatly, greatly appreciated. I have been stuck on this all morning.

[Leith Ross]

Hello webfeet2,

it would be easier to recommend possible solutions if you would post a copy of your workbook.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[webfeet2]

I found the solution to this problem. The following code works on Excel 2007 (have to wait and see with Excel 2003):

Please Login or Register  to view this content.

[webfeet2]

Hello everyone,

I am getting an error when I try to run this piece of code in my spreadsheet. It will work for the first spreadsheet in the list (the list is all in the same column). However, for the other hyperlinks in the column, Excel returns the following message: Run Time Error 9, subscript out of range. The bug is in the following line of code:

Please Login or Register  to view this content.

Any help would be much appreciated.

[Leith Ross]

Hello webfeet2,

Please wrap your code code lines using "code tags". See my signature on how to do this.