Create a list of worksheet with hyperlinks to the respective sheets

Hello friends,

am trying to get a list of cheets which are there in the workbook, with hyperlinks

Have got this code

Please Login or Register  to view this content.

The code works perfectly, but i want the code to work only if sheet 1 is active and also the list should come in Column A of sheet 1 only

what should i add to the code to achive that??

Any idea??

Regards