If you want to make a button to do this, just go to tools > Macros > record
new macro, name it something descriptive and start recording. Then switch to
the worksheet you want and click "stop recording". Then put a button on the
other sheet, right click it and select "assign macro". Choose the macro you
just recorded an voila! you've got a button to switch worksheets.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.