I get this message when I click on a button to run a macro:
"Cannot run the macro ...The macro may not be available in the workbook or all marcros may be disabled."
I do have my macro settings in the Trust Center as "Enable all macros..." and the "Trust access to the VBA project..." enabled
but when I click on the button that is what I get.
And I do have the file saved as a .xlsm and .xls and neither way works. Any ideas?