Solution : Sheet Level Trigger Not Working in AJAX
Since Couple of days I am trying to migrate my dashboard from IE Plugin Mode to AJAX Mode. This comes with bad news that Sheet Level triggers don't run in AJAX Mode. Neither Activate Sheet nor Leave Sheet Trigger. We always heard that VBScript Macro don't work but a JSCript Macro will work.
So we search for one but we don't find any working example for JScript Macro.
So we come up with another way to solve this and now our dashboard is working in AJAX Mode.
We hit that wall a long time ago. The way we worked around this ever since was simply to instead put all the triggers needed on any one sheet on the navigation_button used to access that sheet (on every sheet of our apps, there is a "navigation_bar" on the left with a nr. of buttons, one for every sheet.
This solution sounds very elegant, though. I'll give it a try.