• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 71
  • 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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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