How can I AVOID my Excel file with macros gets unprotected Hi, try this SaveAs the xlsm file as xlsx file and share this, in a public folder also, protect the formulae cells xxxxxxxxxxxxxxxxxxxxxxxxx another approach is to transfer your macros in your PERSONAL XLSB workbook in this way you have an xlsm workbook but without macros