What Should Be Done When Excel Macros Not Working

Macros are quite necessary especially when we are working on repetitive information in Microsoft excel. But sometimes this handy tool may be found inactive or irresponsive what should be done when excel macros are not working?
