A planning function has been added to a button design item in a planning workbook. During runtime there is an error 'Cannot run the macro <Macro Name>. The macro may not be available in this workbook or all macros may be disabled.'
- Create a Planning Workbook.
- Add a button design item which is linked to a planning function and save the workbook.
- Execute the workbook and press the button.
When the workbook is saved after inserting the button and then reopened the event handlers for the button are missing and because of this the button cannot find the macro.
To solve this toggle between design mode and analysis mode in BEx Analyzer. First click into design mode and then back to analysis mode again. This will re-enable the macros and you can use the buttons as usual.
If the problem persists then again open BEx Analyzer. Then through the Excel File Menu open the 'Excel Options' dialog . Select the 'Save' option from the list on the left side and then in 'Save files in this format' select "Excel Macro-Enabled Workbook (*.xlsm)". This should solve the issue.