Action in Command Object

[Anonymous]

Hello!  is there an action in the command object to go back to the last sheet you visited?  I actually created a button to activate a sheet and once you're in , I'd like to go back to the last sheet I visited...I thought the activate previous sheet will work but it doesn't.

Tks.

[swuehl]

If you use buttons to navigate to the sheet, you can additionally store the sheet ID you are coming from in a variable using GetActiveSheetID().

Then use the variable to navigate back.

[maxgro · Accepted solution]

when you leave a sheet you can set a variable (trigger onleavesheet)

see attachment

[Anonymous]

Thank you, Massimo...I finally figured it out...