Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

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....
0
DougDodge
Asked:
DougDodge
  • 2
1 Solution
 
Martin LissOlder than dirtCommented:
With or without the cell being a hyperlink, this works.
Q-28623383.xlsm
0
 
DougDodgeAuthor Commented:
Something so simple.....

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.....
0
 
Martin LissOlder than dirtCommented:
I'm disappointed with the "B". Maybe you'll like this better.
Q-28623383a.xlsm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now