I had the same issue. Macro that I created for sorting, formatting etc and one that I have been using for quite some time, suddenly was not running. THE RUN BUTTON WAS GREYED OUT...!!! THEN IN EXCEL OPTION, TRUST CENTER, MACRO SETTINGS, I JUST HAD TO ENABLE "Trust access to VBA project object model". It is working now.