Use hyperlinked cell to go to a sheet in workbook and then r

[Cosmos75]

I have a macro that creates a summary worksheet (named “Summary”) with the names of all the sheets in the workbook, and then hyperlinks the names to their respective sheets Cell A1.

Is there a way that I can make it easier for the user to go back to the summary sheet without having to use ALT-left arrow?

Anything I can add to the code?

 

[lenze]

First, name Cell A1 on your summary sheet something like "home". Then place a hyperlink on each page to GOTO home. You can use a typed word in a cell, or an Excel object such as a button , shape, or picture. Just select the object, right click and choose Hyperlink

 

[Cosmos75]

Is there anyway to have a macro do that? I have about 30+ sheets and may have to add more in the future.

 

[Cosmos75]

Anybody?