I keep on getting this error message on excel "Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled."
There are quite a few reasons why this error might occur. Refer to this link to see if your solution is available:
"Cannot Run the Macro..."