Capture the previous sheet's name?

  • Thread starter Thread starter Annie
  • Start date Start date
A

Annie

Is there a way to capture the previous sheet's name or other identifier so that a link (or button)
can be added to a page to send the user back from whence they came? I have a worksheet that has
several sheets and a sheet of instructions that would be nice to have a back button on.

Thank you for any help,

Annie
 
Take a look at =hyperlink().

this will take me back to sheet4, A1 (not necessarily the previous sheet):
=HYPERLINK(Sheet4!A1,"Back to sheet4")
 
Annie,

This is not the programming group.
However, in case you could use a VBA solution then
advise and I will post some code that worked for me.

Regards,
Jim Cone
San Francisco, CA
 
Back
Top