Hyperlink doesn’t work for Hidden Worksheets!

[Rajeshkumar R]

Dear Friends,

Need your valuable suggestion on my subjected query…

In the attached workbook, I have Total 7 Worksheets. For Each workbook there is Hyperlink from summary sheet and vice versa…

Hyperlink works only when the worksheets are not hidden. However, I would need

1. Hyperlinks for each worksheets to work even when the sheets are hidden.
2. Example: From Summary Sheet I click on “100% complete object”, I should be able to go to selected worksheet. From “100% complete worksheet”, when I click “summary Object”, I should be able to back on “Summary worksheet” and “100% complete worksheet” must be hidden automatically…
3. Above condition must works for all the worksheets in the workbook.
4. Caution: The Number Hidden worksheets, will keep on increases every week with different name; Hence, kindly provide your suggestions in align with meeting this criteria…

Thanks & Regards,
Rajeshkumar R

[TMS]

You can't hyperlink to a hidden sheet. And, I don't think you can intercept the link to unhide the sheet.

I suspect you'd need to use the click event for the rectangle, something like this:

Please Login or Register  to view this content.

[StevePM]

As far as I know, you will only be able to do this with command buttons on the worksheet and VBA code.