DougDodge
asked on
Looking to set up a Hyperlink to a worksheet
I am looking to set up a Hyperlink to a spreadsheet in a workbook.
It would need to change the properties of the destination sheet from "xlVeryhidden" to "xlVisible", go to that work sheet. And once the user moved to another sheet, the destination sheet would become "xmVeryHidden" again.
Seems to me to be a great way to jump to instruction sheets or tutorials on how to use the spreadsheet developed.
Regards....
It would need to change the properties of the destination sheet from "xlVeryhidden" to "xlVisible", go to that work sheet. And once the user moved to another sheet, the destination sheet would become "xmVeryHidden" again.
Seems to me to be a great way to jump to instruction sheets or tutorials on how to use the spreadsheet developed.
Regards....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm disappointed with the "B". Maybe you'll like this better.
Q-28623383a.xlsm
Q-28623383a.xlsm
ASKER
Not exactly what I was looking for.... but I can modify it. It may become annoying that every time someone enters that cell it jumps to another worksheet.
Thanks for the quick reply.....