Can I link to a sheet without specifying a cell? (1 Viewer)

[RogerCooper]

Can I create a link to a sheet that does not specify a cell, so that the cursor remains on the sheet where it was previously, as if I had clicked on the tab for the sheet?

I am working on a spreadsheet with a long list of financial accounts on the "Accounts" sheet and links to locations on other sheets with detail. I would like to create a link that takes me back to the same cell on the "Accounts" sheet that I was at before I clicked the link. Note that the other sheets may have many accounts referenced on the same sheet and I rather not create a link for each account back.

 

[Gasman]

I doubt it, as each row would be a record? You would need to store you last location.

However easy enough to try out surely?

 

[RogerCooper]

I am just clicking a link. I don't see how I would retrieve the information about the link I just clicked. However, if I click the "Accounts" tab directly, it goes back to where I was in the "Accounts" sheet. Is there a way to simulate clicking a sheet's tab in Excel.

This sheet will be used by other people, so I want to avoid VBA code.

 

[Gasman]

Sorry, I was thinking of linking in Access, did not notice the forum. I just go on What's New.

Have you tried Worksheet("NameOfSheet").Select or Activate ?
However that is VBA, which you do not want to use and that simulates clicking a sheet's Tab in Excel.

 

[RogerCooper]

I will check that out.

 

[Isaac]

Can I create a link to a sheet that does not specify a cell, so that the cursor remains on the sheet where it was previously, as if I had clicked on the tab for the sheet?

I am working on a spreadsheet with a long list of financial accounts on the "Accounts" sheet and links to locations on other sheets with detail. I would like to create a link that takes me back to the same cell on the "Accounts" sheet that I was at before I clicked the link. Note that the other sheets may have many accounts referenced on the same sheet and I rather not create a link for each account back.

use VBA. on the accounts page code an application.goto for the detail pages, and store the 'last place your cursor was' in either a global variable or, better, a place on a hidden worksheet. use the same type of vba, application.goto, on the detail pages to go back to THAT place on the accounts sheet

 

[williamharry]

No, unfortunately, spreadsheet links generally require a cell reference, so they can’t bring you back to the exact previous cell. However, as a workaround, you might consider using a hyperlink to the "Accounts" sheet without specifying a cell, so it at least returns you to the general sheet tab without moving the cursor to a new cell location.

 

[The_Doc_Man]

The problem is that Cells don't have a "my cursor last came from Cell(Z:75)" property. That means you have to store your "last visited" reference point internally in some kind of variable like a single-celled range or however else you want to store it... and that means VBA involvement.

 

[RogerCooper]

No, unfortunately, spreadsheet links generally require a cell reference, so they can’t bring you back to the exact previous cell. However, as a workaround, you might consider using a hyperlink to the "Accounts" sheet without specifying a cell, so it at least returns you to the general sheet tab without moving the cursor to a new cell location.

That is what I have done.