VBA Return to Previous Page

[vbacheck]

I have a button on my worksheet labled "Go Back". I need to assign a macro that will allow me to go back to the previous page. That previous page could be any of 8 different sheets in my workbook.

I copied the following code from another workbook where it performed perfectly but I'm getting the error message: "run time error 9 - subscript out og range".
I have no idea what I'm doing wrong - help!!

Please Login or Register  to view this content.

Moderator Note:

Pls use code tags around your code next time as per forum rules.

[ragulduy]

I don't think you've copied the code correctly. You need to assign the variable lastsheet to something otherwise your goback macro will be the equivalent of:

Please Login or Register  to view this content.

I'd guess your missing something along the lines of:

Please Login or Register  to view this content.

Which should be stored in your "thisworkbook" object module.

[Ron Coderre]

Copy this code and paste it into your general module...

Please Login or Register  to view this content.

For each worksheet in your workbook that you want to be able to go back to:
• Right-click on the tab name...select: View Code
• Copy the below code and paste it into the sheet's module

Please Login or Register  to view this content.

Now, whenever you run the GoBack program...the last deactivated sheet (containing that code) will be activated.

Is that something you can work with?

[vbacheck]

That worked perfectly - thx!!!!