Force Save as Macro-Free file

[stuartgb100]

Hi,

I have a template file with a protected Project.
When opened, code runs leaving a user workbook open.
This user workbook is macro-enabled and contains the protected Project.
The code has been modified to allow the user to work with the file.

When the user is ready, they click a button, and a bunch of emails are sent.

Question: can I then force a save of the workbook, but with the Project removed ?

Many thanks.

 

[yky]

Set file format to 51, which is a workbook without macro.

ThisWorkbook.SaveAs Filename:="D:\myfile", FileFormat:=51