Go to Previous Sheet

Many of you use buttons to navigate among your sheets. Have you ever wanted to create a button that takes you back to the sheet you came from?


Easy-peasy.

1. Create a new variable named vSheetFrom
2. On your button that takes you to the new sheet, add a Set Variable action. In the value box, type =GetActiveSheetId()
3. On the second sheet, create a button with a Activate Sheet action. In the value box, type =vSheetFrom

Save and marvel at your cleverness.