I have a macro that will copy a sheet and then save it as a CSV format. It uses the Application.GetSaveAsFilename to get the location and file name, then I use the With Activeworkbook .saveas to save the file.
It does save the file just fine in the compiled version, but after it save the file to csv, it will prompt the users to save the local workbook in a secured file format .xlsc. Even if I go along and say to save it, it doesn’t actually seem to update the file with any changes. My preference would be to not have this second “secured” file save be asked at all.
The only security setting that I have enabled is “Allow secure save”