Just a thought:
Distribute the Workbook with Forms and Macros, But save the Data to a Teams Spreadsheet