OnActivate Sheet trigger not working when activating sheet using a field event trigger

[#1]

Hi,

I have an OnActivateSheet trigger on some of my sheets and it works fine. In order to satisfy a new requirement, I have had to put all the possible sheet choices into a listbox/multibox and I am using an if statement in a field event trigger to display the relevant sheet depending on the choice selected.

This works fine, but the issue I have is that the OnActivateSheet sheet triggers do not work when I activate the sheet this way using the listbox/multibox and I need the sheet triggers to also work when the sheet is activated after the selection is made.

Has anyone encountered this before and if yes, any suggestions to resolve this?

Note: My installation does not allow the use of macros, so that is not an option.

Many thanks

[Nicole-Smith · Accepted solution]

I've encountered this before.  The only thing I was able to do was to add the same triggers that were on the OnActivateSheet to the field event trigger.

[#3]

Thank you. Your suggestion will address the issue on some of the sheets, but not all of them.

I'll probably have to use an alternative approach as I don't want the same second action happening on all the sheets.

[Nicole-Smith]

Maybe you could use GetActiveSheetId() to determine if you're on a specific sheet, and if you are, then do the trigger.  I don't know what your triggers are, so I can't help you write exactly what you need...