How to return to "original" sheet after using a link to a other sheets?

I have a workbook with about 200 sheets.
Each sheet contains lots of links to the other sheets, so the user can clink the link and then go to the new sheet.

But, how do I make a "return-function"? That can return the user to the sheet that was active before the link was followed? If possible I would like this do be doable for 5-10 sheets back.

This "return-function" is gonna be used by clicking a button on a floating toolbar I have connected to the sheet. (This I dont need help with, just the "return-function").

Would very much appreciate help with this.
Best regards

You could use an array for this. On the open event of the workbook use the activesheet.name to add this to the array and then using the SheetActivate event add sh.name to the array each time. This in combination with some sort of counter should allow you to achieve what you want.

Hi Chergh
Thanks for your replay

I understand what you mean. But I am unsure about the coding, how to do it.

I'm not sure how to code it yet myself and would need to give it a good bit of thought, so I will need to wait till I'm not at work.

Originally Posted by royUK

This is a bit confusing. Are you using hyperlinks to move to a sheet or VBA?

If you are using VBA then you capture the active sheet's name in a variable, then use this in your go back to code

Please Login or Register  to view this content.

Why do you need 200 sheets, seems excessive to me.

Hi royUK

The workbook was this way when I got it, with many sheets that is.
I will get more workbooks like this so I guess I just have to deal with it this way.

The links are just simple hyperlinks, not written or done with any VBA.

Originally Posted by royUK

If you aren't using code then you I don't think you can return to the last sheet.

You mentioned that you were using a "floating toolbar" which has to use VBA code.

Read this page, there's some code to create a hyperlinked index page 7 an addin that will allow you to navigate from sheet to sheet.

Thank you.
I will be looking into the toolbar, see if I can use it somehow.

broro183, I also want to thank you for the links.

I will get back here in the thread how it goes

Originally Posted by royUK

This is a bit confusing. Are you using hyperlinks to move to a sheet or VBA?

If you are using VBA then you capture the active sheet's name in a variable, then use this in your go back to code

Please Login or Register  to view this content.

Why do you need 200 sheets, seems excessive to me.

Is it possible for me to use this code, or anything like this?
If so, where to put the code so it is executed every time a new sheet in the workbook is activated?