Worksheet Names macro that pastes names as hyperlinks

**bungaree** · 07-04-2013, 05:53 PM

Good morning forum, I have the macro below which pastes all the names in my file (there are lots) in column A.

Is there anyway I can get the macro to paste the names as hyperlinks so that I can just click on the name to go to that sheet?

Failing that, is there a formula which will convert the name into a link?

Help will be much appreciated!

Please Login or Register  to view this content.

**watersev** · 07-04-2013, 06:35 PM

hi bungaree, hyperlink to each sheet A1 cell

Please Login or Register  to view this content.

**martindwilson** · 07-04-2013, 06:46 PM

you could with sheet name in a1 use in b1
=HYPERLINK("#"&CHAR(39)&A1&CHAR(39)&"!A1",A1)
or
=HYPERLINK("#'"&A1&"'!a1",A1)

**bungaree** · 07-04-2013, 07:15 PM

How incredible is this forum - thank you both for your very quick responses!

Watersev, I couldn't get your code to work on my named worksheets, it only worked as a link for the default Excel sheet names. Not a problem, because Martin, I didn't even think to look for a formula! And both of yours work a treat.

Thank you both so much again.
Happy day

, Bungaree