VBA for last active worksheet

[johannes2008]

Hello All

I am wondering if anyone knows the code that I can put in a button that will take me back to the last active worksheet, not necessarily the previous worksheet in the worksheet order. My sheets all have names with spaces.

Thanks
-Johannes

 

[Joe4]

Hello clever peeps.

I appreciate this thread is very old now, but I was just wondering why this code isn't working for me (Joe4, not ZVI as unfortunately this doesn't work at all for me and disables all the other macro buttons I have!). I have the codes in the correct place (at least I think I do! Where is the 'Public Variable' code put (I put it in 'ThisWorkbook' and then in every sheet)), assigned the macro to a button, switched sheets (both via macro buttons and tabs), but keep getting the message, "You have not switched sheets yet since opening the file!"

Any guidance would be gratefully received!

Sorry, I never saw this, as I wasn't subscribed anymore to the thread.

So, you should put the Worlbook_SheetDeactivate procedure in the "ThisWorkbook" module.
Then the Public variable declaration and other procedure should go in a new, standard module (insert a new module and enter that code there).