look for sheet name in list and creat hyperlink to cell
 

I have a large Workbook with a hyperlink to a spreadsheet (same workbook)
with history on it. When you click the hyperlink it takes you to that sheet
R1,C1. In that sheet R1,C1 I would like to return to the cell from the
previous link. example I click on R55,C1 on the master sheet and it takes me
to sheet 71 R1,C1. I would like to click on this cell and return to the
master sheet R55,C1. This work book has 240 Link/sheets. Do I use a look up
for this?

look for sheet name in list and creat hyperlink to cell
 

In each sheet, create a hyperlink in A1 that points to anything, it doesn't
matter. Then in each sheet's FollowHyperlink event, put:
Worksheets("MasterSheetName").Activate

It will ignore the hyperlink and take you back to the first sheet. By
default, it will select the previously selected cell on that sheet.

HTH,
Barry

"Jax" wrote:

I have a large Workbook with a hyperlink to a spreadsheet (same workbook)
with history on it. When you click the hyperlink it takes you to that sheet
R1,C1. In that sheet R1,C1 I would like to return to the cell from the
previous link. example I click on R55,C1 on the master sheet and it takes me
to sheet 71 R1,C1. I would like to click on this cell and return to the
master sheet R55,C1. This work book has 240 Link/sheets. Do I use a look up
for this?

look for sheet name in list and creat hyperlink to cell
 

Barry,

I am a low level user but what the boss wants the boss gets! I have been
reading about followhyperlink event but I do not understand how to use this.

"Barry Gilbert" wrote:

In each sheet, create a hyperlink in A1 that points to anything, it doesn't
matter. Then in each sheet's FollowHyperlink event, put:
Worksheets("MasterSheetName").Activate

It will ignore the hyperlink and take you back to the first sheet. By
default, it will select the previously selected cell on that sheet.

HTH,
Barry

"Jax" wrote:

I have a large Workbook with a hyperlink to a spreadsheet (same workbook)
with history on it. When you click the hyperlink it takes you to that sheet
R1,C1. In that sheet R1,C1 I would like to return to the cell from the
previous link. example I click on R55,C1 on the master sheet and it takes me
to sheet 71 R1,C1. I would like to click on this cell and return to the
master sheet R55,C1. This work book has 240 Link/sheets. Do I use a look up
for this?

look for sheet name in list and creat hyperlink to cell
 

Open the VBA editor (Alt-F11). In the Project Explorer (F4 if you don't
already see it on the left), you'll see references to each worksheet.
Double-click one of these (for one of your sub-sheets). In the dropdown on
the top-left (above where it says "Option Explicit"), select Worksheet. In
the dropdown to the right, select "FollowHyperlink". This is the event where
you'll put your code:

Worksheets("MasterSheetName").Activate

I hope I'm not being too elementary or not clear enough.

Barry

"Jax" wrote:

Barry,

I am a low level user but what the boss wants the boss gets! I have been
reading about followhyperlink event but I do not understand how to use this.

"Barry Gilbert" wrote:

In each sheet, create a hyperlink in A1 that points to anything, it doesn't
matter. Then in each sheet's FollowHyperlink event, put:
Worksheets("MasterSheetName").Activate

It will ignore the hyperlink and take you back to the first sheet. By
default, it will select the previously selected cell on that sheet.

HTH,
Barry

"Jax" wrote:

I have a large Workbook with a hyperlink to a spreadsheet (same workbook)
with history on it. When you click the hyperlink it takes you to that sheet
R1,C1. In that sheet R1,C1 I would like to return to the cell from the
previous link. example I click on R55,C1 on the master sheet and it takes me
to sheet 71 R1,C1. I would like to click on this cell and return to the
master sheet R55,C1. This work book has 240 Link/sheets. Do I use a look up
for this?

look for sheet name in list and creat hyperlink to cell
 

Barry,

elementary is my middle name. It work great and thank you for your help.
When I entered the hyper link in the other sheet I set it to "master list
R2,C1". When I changed the hyperlink to somewhere on the same sheet it worked
great! thank you again.

Jack (I learn slow but well)
"Barry Gilbert" wrote:

Open the VBA editor (Alt-F11). In the Project Explorer (F4 if you don't
already see it on the left), you'll see references to each worksheet.
Double-click one of these (for one of your sub-sheets). In the dropdown on
the top-left (above where it says "Option Explicit"), select Worksheet. In
the dropdown to the right, select "FollowHyperlink". This is the event where
you'll put your code:

Worksheets("MasterSheetName").Activate

I hope I'm not being too elementary or not clear enough.

Barry

"Jax" wrote:

Barry,

I am a low level user but what the boss wants the boss gets! I have been
reading about followhyperlink event but I do not understand how to use this.

"Barry Gilbert" wrote:

In each sheet, create a hyperlink in A1 that points to anything, it doesn't
matter. Then in each sheet's FollowHyperlink event, put:
Worksheets("MasterSheetName").Activate

It will ignore the hyperlink and take you back to the first sheet. By
default, it will select the previously selected cell on that sheet.

HTH,
Barry

"Jax" wrote:

I have a large Workbook with a hyperlink to a spreadsheet (same workbook)
with history on it. When you click the hyperlink it takes you to that sheet
R1,C1. In that sheet R1,C1 I would like to return to the cell from the
previous link. example I click on R55,C1 on the master sheet and it takes me
to sheet 71 R1,C1. I would like to click on this cell and return to the
master sheet R55,C1. This work book has 240 Link/sheets. Do I use a look up
for this?

look for sheet name in list and creat hyperlink to cell
 

Barry,

Is there a way to automate this across multi-sheets (the count is 22
workbooks with 240 sheets each). Thank you for your time.

"Jax" wrote:

Barry,

elementary is my middle name. It work great and thank you for your help.
When I entered the hyper link in the other sheet I set it to "master list
R2,C1". When I changed the hyperlink to somewhere on the same sheet it worked
great! thank you again.

Jack (I learn slow but well)
"Barry Gilbert" wrote:

Open the VBA editor (Alt-F11). In the Project Explorer (F4 if you don't
already see it on the left), you'll see references to each worksheet.
Double-click one of these (for one of your sub-sheets). In the dropdown on
the top-left (above where it says "Option Explicit"), select Worksheet. In
the dropdown to the right, select "FollowHyperlink". This is the event where
you'll put your code:

Worksheets("MasterSheetName").Activate

I hope I'm not being too elementary or not clear enough.

Barry

"Jax" wrote:

Barry,

I am a low level user but what the boss wants the boss gets! I have been
reading about followhyperlink event but I do not understand how to use this.

"Barry Gilbert" wrote:

In each sheet, create a hyperlink in A1 that points to anything, it doesn't
matter. Then in each sheet's FollowHyperlink event, put:
Worksheets("MasterSheetName").Activate

It will ignore the hyperlink and take you back to the first sheet. By
default, it will select the previously selected cell on that sheet.

HTH,
Barry

"Jax" wrote:

I have a large Workbook with a hyperlink to a spreadsheet (same workbook)
with history on it. When you click the hyperlink it takes you to that sheet
R1,C1. In that sheet R1,C1 I would like to return to the cell from the
previous link. example I click on R55,C1 on the master sheet and it takes me
to sheet 71 R1,C1. I would like to click on this cell and return to the
master sheet R55,C1. This work book has 240 Link/sheets. Do I use a look up
for this?