I´m having a similar problem. Whe are trying to get rid of macros specially of the one we use in the menu.
A field contains the names of the dashboards while another one has sheets ids - they have a one-to-one relationship. When I click on a list with the dashboard name field, a "On select" document trigger activates the sheet (using the sheet code field). It does work perfectly, but it also deactivates the "On Activate Sheet" triggers of the activated sheet.
I figured out this action works when I use a button or a text object. Maybe it happens because they have their own triggers and don´t require document triggers.