Solved | Can't save workbook macro-free
Have you seen this error when saving your Excel workbook?
Or this, just below the ribbon?
It may be you've accidentally double-clicked an Active X control when in Design mode; or taken some other action to cause Excel to create a macro for you. Assuming you don't want to macro-enable your workbook, try the following ways to clear the error.
Let Excel try to reverse the actions that let to this error
Click the Yes button
Try to save your workbook
If the problem persists, proceed as below.
Delete Code from Microsoft VBA window
Select the Developer menu in the Ribbon
Click the Visual Basic button
Identify your workbook. The bottom left panel of the VBA window will show each of the open workbooks. It's important to identify your workbook, as you don't want to be playing around with code in someone else's workbook.
Having identified the correct workbook, double-click on each of the Excel objects in turn and review each code window in turn.
If there's just empty macros, then you can safely delete all the code
If there's something that looks intentional, then you can still delete all the code, but you may you would like to save the workbook as macro-enabled after all.
Close the VBA window
Save your workbook.