Thread: Hyperlinks and Hidden Sheets
07-04-11, 16:25 #1Registered User
- Join Date
- Apr 2006
- Huddersfield, UK
Unanswered: Hyperlinks and Hidden Sheets
Just wondered if it is possible in excel to create on a sheet (call it say cover sheet) with links to sheets that I intend to hide as these sheets provide background data thats not neccessarily important, but on the cover sheet still have access to these via a hyperlink or such?
dansometimes simple is best.... and i'm just a simple fellow.
07-05-11, 04:03 #2Registered User
- Join Date
- Jun 2011
It is easy enough to create a hyperlink to another sheet..
Insert > Hyperlink > "Place in this document"
You can then change the targeted place to a sheet name or defined range. Only problem is that this doesn't work if the sheet you are referring to is hidden.
You could use a macros maybe attached to a button or a cell to unhide a sheet and then to select a specific area on that sheet.. something like the below should work....
' Macro1 Macro
Sheets("Sheet2").Visible = True
You would then need another button or macro to close the sheet and return to the original page. If you are unsure of macros there is a record button which is sometimes easier, it will record your actions and you can then adapt it to what you need.