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?

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?

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?

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?

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?

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?