Solved

Looking to set up a Hyperlink to a worksheet

Posted on 2015-02-24
3
56 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

765 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