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

Cosmos75 · Apr 12th, 2002, 11:54 AM

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 · Apr 12th, 2002, 12:01 PM

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 · Apr 12th, 2002, 12:45 PM

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

Cosmos75 · Apr 14th, 2002, 10:47 PM

Anybody?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 11:54 AM	#1
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	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?

Apr 12th, 2002, 12:01 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	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

Apr 12th, 2002, 12:45 PM	#3
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	Is there anyway to have a macro do that? I have about 30+ sheets and may have to add more in the future.

Apr 14th, 2002, 10:47 PM	#4
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	Anybody?