Hyperlink links to validation list, but will not display sheets when hidden . . .

[Learner123]

Hi World,

I am having a problem setting up a Hyperlink to hidden sheets.

My workbook has numerous sheets that link into a master sheet. The master sheet contains a validation (drop down menu) that feeds into a hyperlink formula.

If I were to click on a specific value within the validation (drop down menu), the Hyperlink value changes respectively. Then, if I were to click on the Hyperlink, it brings me to the appropriate sheet. However, if the sheet is hidden, the hyperlink will not work.

Is there anyone out there who can help me with this issue?

Thank you in advance for your time!

V

 

[Learner123]

I appreciate your continuing help!

After making the above mentioned cell adjustment (code now refers to the DV list), the hidden cells activate when Data Validation is chosen. However, my goal is to activate the hidden sheets via the hyperlink.

Is this possible? Would you know of a code that can do this?

Just a side note: The hyperlink uses the DV as a driver and (if clicked on) activates the DV sheet when it is unhidden. However, it will not activate the DV sheet if the sheet is hidden.

 

[Smitty]

If you're using the change event to unhide/activate the sheets directly why do you even need the hyperlink?

 

[Learner123]

When DV is selected the sheet, which DV resides in, populates with multiple information that pulls from the hidden sheets.

I want to be able to activate the hidden sheet via hyperlink in order to update the hidden sheets, which ultimately feed into the sheet where the DV resides.

Sorry if this sounds confusing...