Solved

Looking to set up a Hyperlink to a worksheet

Posted on 2015-02-24
3
53 Views
Last Modified: 2016-02-11
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
Comment
Question by:DougDodge
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 40628644
With or without the cell being a hyperlink, this works.
Q-28623383.xlsm
0
 

Author Closing Comment

by:DougDodge
ID: 40628802
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
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40629181
I'm disappointed with the "B". Maybe you'll like this better.
Q-28623383a.xlsm
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013 and later. Also included is a preconfigured error box to be used in error handling.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now