Excel 2013 Cannot Run the Macro....The Macro May Not be available in this workbook or all macros disabled

[riclop]

I've come across this behavior on two different occasions now. I have a workbook that is password protected for write access. I've written a macro and assigned it to a shape. In Excel 2010 I am able to execute the macro without any troubles both in Read-Only as well as Edit mode. When I open up the same file in Excel 2013 (in either Read-Only or Edit mode) and I click the shape that the macro is assigned to I receive a message box,

"Cannot run the macro "<my macro name>". The macro may not be available in this workbook or all macros may be disabled.

In read-only I try to reassign the macro (using the right click menu of the shape). I find the macro I want to (re)assign, highlight and select OK. I then double-click the shape to run the macro. I get the message in Excel asking to input the password or open the file as read-only. I click read only and it reopens the file. I'm still unable to execute the macro.

In edit mode I try to reassign the macro (using the right click menu of the shape). I find the macro I want to (re)assign, highlight and select OK. I then double-click the shape to run the macro. I get the message "File in Use". I'm still unable to execute the macro.

Any thoughts out there as to why in Excel 2010 I have no troubles but in Excel 2013 it wants to open another copy of the same workbook?

 

[PKFillmore]

Has anyone figured this out yet? Im having this exact issue and cant find a solution

 

[vogel997]

Did you save the file as a " .xlsm " file?