Create copy of current workbook and save as filename in cell

[ExcelPhil]

Hi guys,

I have a spreadsheet I use as a template for employees to fill in.

I would like to save the workbook after employees have entered details under their name located in cell M1 but not overide the current template.

So they start by opening the spreadsheet template.xlsm.

Enter their details and press a custom save button.

Saves their details to new file EmployeeName.xlsm

But doesn't save anything to template.xlsm.

Can anyone help me with the VBA code for this?

Any help would be greatly appreciated.

Thanks.

 

[Trebor76]

Hi ExcelPhil,

Instead of code why not just make the file read-only by the following four steps:

1. Right-clicking on the file (ensuring it's closed) in Windows Explorer
2. Select Properties from the shortcut menu
3. Clicking the Read-only checkbox of the Attributes options from the General tab
4. Click OK

You will of course have to remove the read-only property if you need to make any changes to the file.

Regards,

Robert

 

[ExcelPhil]

Hi ExcelPhil,

Instead of code why not just make the file read-only by the following four steps:

1. Right-clicking on the file (ensuring it's closed) in Windows Explorer
2. Select Properties from the shortcut menu
3. Clicking the Read-only checkbox of the Attributes options from the General tab
4. Click OK

You will of course have to remove the read-only property if you need to make any changes to the file.

Regards,

Robert

Thanks Robert I will give that a go.