If you want these macros to run themselves, then you can use event macros to check these sheet values anytime a value is manually changed on that sheet. Would that suffice? It would be a different macro that checked these cells if any change occurs on ANY sheet.

1) Would the macro you run result in C2 no longer being equal to 5, because if this macro runs anytime a change occurs anywhere on the sheet and C2 value isn't changed by the macro results, then that macro would get triggered over and over again.

2) The multiple-trigger problem isn't as big a deal on this one since it would simply be making a shape visible/invisible, right?