Adding VBA Hyperlink to each worksheet

Hi All,

I have got some useful codes for my project to automatically generating worksheets of each individual employee in the active workbook. Please see below codes for the same:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Could you please tell me how to automatically add hyperlinks from each employee's ID to his unique individual worksheet, so whenever we run the above codes for automatically generating the worksheets, then all of those worksheets have a hyperlink form the main worksheet - "Monthly Productivity Data".

For example: If a new sheet is generated with a name as Tom Cruise then a hyperlink should appear on his ID on the main worksheet Monthly Productivity Data. so we can visit his unique worksheet on a simple click.

Workbook: MS Excel 2003

Thanks in advance!

Plz find the attached workbook for more details.

Superrrb!!

your codes are fantastic, better in all the ways!
Could you please automatically send the relevant data from Monthly Productivity Data worksheet to each employees worksheet. Please check out the attached for an example, so I don't have to copy & paste the values again & again.

This is exactly what I wanted!! WOW!!

Thanks Thanks Thanks a world for ur awesome help!

Done!! oops how did I forgot it! :P
Thanks again!