Toggle to next sheet object without impact

[Anonymous]

Hi  all

I want to toggle to next sheet object if i click any cell on the straight table..

I have a sheet which is having straight table,filters... now if i click any cell on straight table it should move next sheet.. where as if i click on any filters it should be on the same sheet.

Hope it is easy and clear.

[Anonymous · Accepted solution]

Create a Transparent textbox and overlay your straight table and add an action to Activate Next Sheet

Set the textbox layer to always be higher than your table

Example attached.

[Anonymous]

any help!