VBA macro to autofill Incrementing Hyperlinks to Local Sheets

Hi Guys,

I am trying to use VBA to create a hyperlink to many sheets in my workbook,

the sheets are: Account (1), Account (2), Account (3) etc etc etc

I have been trying to use this code:

Please Login or Register  to view this content.

however I think this code will only work for External links and not links to the individual sheets in my workbook.

Can this code be ammended to function on Local links or is there an easier way to do this?

I need over 500 links in total as my workbook contains over 500 sheets.

Thanks

Try with this code:

Please Login or Register  to view this content.

Regards,
Antonio