| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinking to a hidden workbook
Hi,
I currently have a spreadsheet which adds hyperlinks to a summary sheet in column 2 and has data sheets for the people who's names are listed in column 1. The sheets which hold the data are currently hidden (just to make it look tidier) and I am wondering how to go about unhiding and then activating the relevant sheet (as per column 1) after clicking on the hyperlink to it. Is it possible to do this, or am I best just leaving the sheets unhidden? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hyperlinking to a hidden workbook
I'd take a look at the FollowHyperlink event and see if it helps you
http://www.tushar-mehta.com/excel/tips/hyperlinks.html -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Wullie" wrote: Hi, I currently have a spreadsheet which adds hyperlinks to a summary sheet in column 2 and has data sheets for the people who's names are listed in column 1. The sheets which hold the data are currently hidden (just to make it look tidier) and I am wondering how to go about unhiding and then activating the relevant sheet (as per column 1) after clicking on the hyperlink to it. Is it possible to do this, or am I best just leaving the sheets unhidden? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlinking to a sheet in an excel workbook | Excel Discussion (Misc queries) | |||
| Rows hidden by Autofilter vs hidden by changing the Hidden property | Excel Programming | |||
| hyperlinking to hidden work sheets | Excel Discussion (Misc queries) | |||
| Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
| How to hide a workbook and to detect a hidden workbook in visual basic | Excel Programming | |||
Hybrid Mode
