Jenny has attended:
Excel Advanced course
Hyperlinks to hidden worksheets
I have set up hyperlinks to worksheets in the same workbook. These work until I hide the worksheet, is there anyway I can hide worksheets and the hyperlinks still work?
RE: Hyperlinks to hidden worksheets
Hi Jenny
Thank you for your question. I regret to say that as I understand it the only way to make this work is to use the Visual Basic programming language to create your own instructions to show or hide the sheets.
I am sorry I couldn't be of more help.
Kind regards,
Andrew