Export one worksheet, values only to new passwordprotected sheet

[jokkebal]

Hi,

I have a multisheet workbook. One of these sheets contains various formulas. I want VBA to :

• export this one sheet to another file
• make that all fields in this file are values, so no formulas
• password protect the new file

At the end of the VBA script, I wish that the new file is closed and that I still have the original file open.
Is this possible ?