Libre calc is a great replacement imo. It has support for excel vba macros, but you can also make macros in Python, JavaScript, and their own macro language. For the most part it’s cross compatible with excel, but doesn’t support their xlsm file type as far as I know.