thank you my friend. Helps majorly.
I also understood the difference between xlhidden and xlveryhidden :), getting there.
This works.. I'll test it on the original file tomorrow morning.
However, for this to work I noticed tat the names in the text box needs to match the the worksheet name...
Hey Narayan ... can you please help me with that post in this thread?
http://forum.chandoo.org/threads/how-to-hyperlink-to-cells-in-hidden-worksheet.18906/page-2#post-207416
much appreciated :).
Regards
Hey thanks for your reply Narayan. It was an old thread, I was not sure if it's still active.
Please see the attached template. The final file is quite the same.
This is the code (copying from above) I used in the original file.
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
If...
Guys.... I am using a very similar sheet. I am able to navigate away from the other worksheets. However, when back in home it doesn't seem to accept the links in the home worksheets.
Also those sheets identified in the code shared by Narayana aren't showing up under the 'unhide' list (on right...