Hello,
I am trying to create a calc xlsm file that uses macros and buttons, but it is not saving either of them. I am unsure why. Any help is appreciated.
Use the native, international standard ODF file formats (.ods) for your important documents, especially for those that contain macros.
Never was and never will be 100% compatibility with the foreign file formats.
Additionally, if you really need to export to a MS-Excel format then do it only when needed, not for saving and loading the daily work, and then use .xlsx OOXML (Excel 2007-365) instead of .xlsm (the latter is supported only rudimentary), which should at least preserve form controls; macros will continue to work in Excel only if they are written VBA-compatible.