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