Multiple Sheets and one back button Trigger..

[Anonymous]

Dear All,

Can we go back with activate sheet button trigger to multiple sheet.

Say, I am having 2 sheet Analysis1 & Analysis2 and 1 Report sheet Report1.

Now I have given link of Report1 sheet on both the Analysis sheet.

Now I want, If I am on Analysis1 and going to Report1, then If I use Go Back Button on Report1 with Activate Sheet Trigger..I should go back to Analysis1 only..

Similarly For Analysis2.....with One Button only in Report1..

Is it possible?

Any workaround?

Regards,

Balraj Ahlawat

[sorrakis01]

Hi,

you can create a variable, values 1 or 2 for example. If you coming from Analysis1 variables value is 1 and 2 for the Analysis2. When you press the button in Report's sheet use conditional and evaluate the variable in the trigger .. If variable=1 then go to Analysis1 and if is 2 go to Analysis2.

Regards

[sunny_talwar · Accepted solution]

See if this discussion helps: Back to previous sheet with a text object.