Solved

Looking to set up a Hyperlink to a worksheet

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

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 45

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

706 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

19 Experts available now in Live!

Get 1:1 Help Now