I want to use a Macro to conditionally call 1 of 2 macros

I have a worksheet called "DO NOT DELETE" that has a cell (E54) with a YES
or NO in it.

If it is YES, I want to call a macro called tagright and if it is NO, I want
to call a macro called tagrightno

Any help would be greatly appreciated.