Adjust my VBA so the cell becomes a hyperlilnk to a Sheet

**Cidona** · 06-21-2012, 07:54 AM

Dear Forum

The VBA below creates a new sheet based on a template. It also renames the new sheet. It also then reports certain information from this new sheet into a 'Summary' sheet.

All is well. However in regards to this line of the code:

Please Login or Register  to view this content.

As well as this being reported on the summary sheet, I would like the cell on the Summary Sheet to automatically be a hyperlink to the relevant sheet.

Anyone know how to manipulate the code to do so?

Below is the complete 'macro'.

Thank you for any assistance you can provide!

Please Login or Register  to view this content.

**MarMo** · 06-21-2012, 08:32 AM

Hi Cidona ,

Didn't know about this , but looked it up.
Can this help you?

Please Login or Register  to view this content.

Krgds
Mario

**Cidona** · 06-21-2012, 10:29 AM

Hi Marmo.

Thanks for the input. However I copied and pasted that line in and I get a 'Compile Error' stating 'Expected: end of statement'.

Please find attached sheet.

Any ideas?