hyperlink in hidden sheet

[edwinculanding]

kindly need help to know how to make hyperlink in hidden sheet?

i have 1 SUMMARY sheet & i have other 9 sheets with name LOOP1 up to LOOP 9 but this is hidden and only the summary appear.

so if i click the words LOOP1 up to LOOP9 in the cell inside the summary sheet it will direct to this sheet even if this hidden.

i hope i explain it clearly.

thanks a lot.

[GeneralDisarray]

you are better off using event macros instead of hyperlinks. See the attachment

First macro, hides all except for the summary sheets when the summary sheet is first activated (when you click on the tab to view that sheet, the LOOP sheets are all hidden)

Second macro, unhides and shows the LOOP sheet you have selected.

Both event macros are tied to the summary sheet, and the names of the other sheets must match the values shown "LOOP 1", etc..

Please Login or Register  to view this content.

[edwinculanding]

thanks a lot general.

it worked.

but if i have different sheet names? for example "loop", "line", etc


edwin

[GeneralDisarray]

do you mean, different from the name that appear on the "Summary" sheet? You can edit the macro to handle different names.... what exactly do you need?