• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink to Hidden Sheets

Status
Not open for further replies.
N

nicoleoneaus

New Member
Hi Guys,
I'm new to VBA macros and have struggled to understand the code that is required to Hyperlink to hidden sheets. I have a dynamic calendar with HYPERLINK (concantrate) beneath the dates, with sheets of the same date. Its supposed to be an interface that links to various daily schedules according to the date. Because all the sheet names are dates and not days, its very confusing so I want to hide all the sheets and just have the links to them and then once they leave the page it closes. Can anybody help me?
 
nicoleoneaus
Are You writing Ask an Excel Question or VBA Macros- question?
If VBA Macros then this should move there.
... could You use something else than Hyperlink?
... Hiding and show is possible to do.
Do You have for each day own sheet? ... ~365 sheets per year?
Could You use one sheet for eg per year? .. and (Auto)Filter wanted days data to see?
A screenshot ... it's a challenge to get clear idea ... to test or verify with it.
A real sample Excel-file would be 99% better.
 
Status
Not open for further replies.
Back
Top