Activate tab when other is hidden by condition

[elinamcastelletta]

Hello,

By default, the First tab is Activated after a sheet is hidden due to a change in selections that affects the condition to show it.  I need to Activate other tab instead of the First. How can that be set up?

Thanks

[derekjones · Accepted solution]

Use Activate Sheet in your trigger? Example attached using a button, but trigger could be on anything else e.g. Tab select, object select etc