Test the macro after saving 1. Test the macro after saving Once the file is saved as .xlsm, close it and then reopen it. If the security settings are correctly configured, Excel will ask if you want to enable macros. Click Enable Content to allow your macro to run. 2. Tip for automating saving If you frequently create files with macros, you can create an .xltm template (Excel template with macros). This way, every new file based on this template will support macros without having to reconfigure it each time. 3. Summary and long-term solution To avoid re-entering your macro each time: Save your file as .xlsm Place the code in ThisWorkbook Enable macros in the security settings Test opening and running the macro Use an .xltm template if needed