• 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

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've made a day calendar with dates that change according to a list down menu of months. I've then put a cell under each day with a HYPERLINK (concantrate) linking to the generated number generated by the day formula. The link requires me to make sure the sheet and generated number is the same, allowing a user to click the button taking them to the relevant sheet. The problem is I have to name the sheet a long number to match the populating number the formula is making, and because of this the pages are unidentifiable as they don't have dates but instead have seemingly random numbers. Thus I wanted to hide all the sheets and have the calendar be the only way to open a sheet. But I can't seem to figure out how to hyperlink to hidden sheets and close the relevant sheet when I close the document. The end goal is to link up about two months of sheets starting from September-October.

Currently I've linked 5th Sep -12th Sep (meaning if you click the button under those dates, it will link you to the sheet which has the same sheet name as the generated number. Can anybody help me?



I've attached the file.
 

Attachments

  • Day Calander.xlsm
    348.2 KB · Views: 3
nicoleoneaus
Did You read my questions from Your previous same thread?

Hyperlink to Hidden Sheets

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...
chandoo.org
 
Yes sorry...
I don't have a sheet for 365 days, I've manually made one week between the 5th-12th but the goal is to have one for every day of the year to display different tables on it. The tables are supposed to have daily schedules of various people, and two weekly schedules showing the data vertically and horizontally. In addition to this I'm considering having a toggle function with a list, that pulls up each persons daily schedule and to isolate them from everyone else for printing reasons. Your idea to auto filter, I'm unsure what that means?
 
nicoleoneaus
the goal is to have one for every day of the year... means ~365 sheets - instead of one sheet.
Your daily sheets looks that there are only one data column and each daily sheet has same time-column.
Your daily sheets don't have any data now, which could show more about Your plan.
You'll create huge size file.
Please, try to search about AutoFilter/Auto-filter.
I would do that different way.
 
You must log in or register to reply here.
Back
Top