You can use the FollowHyperlink event in your index sheet.
However, xl97 doesn't have that event.
See...
http://makeashorterlink.com/?G4451192B

Jim Cone
San Francisco, USA




"mastee" <mastee.1pr1qc_1117296301.7935@excelforum-nospam.com> wrote in
message news:mastee.1pr1qc_1117296301.7935@excelforum-nospam.com...
> Hi,
> can someone help me i want to create a index sheet with all the
> hyperlinks and hide the worksheets after that .When i click the
> hyperlink the hidden worksheet should open and allow me to print the
> sheet.
> I WILL BE GRATEFUL IF SOMEONE AN HELP ME ON THIS MATTER.
> Mastee