Save file only if filename is not equal to a specific name

[rustym]

Hello
I have created a worksheet as a template in Excel 2003 and I don't want it to be altered. The idea is that the user should only be able to save the file if they change the filename to something else other than "template.xls". They should still however be able to fill in cells and run macros from it as long as they don't save the changes.

I know that I need to use the Workbook_BeforeSave but I am having troubles with how to implement the code.

Any ideas would be greatly appreciated.

Cheers,

Rusty

 

[Joe4]

Why not just set the file to be Read-Only (in Windows Explorer -> Properties)?

This will allow the users to make any changes they want, but will NOT allow them to do a "Save" on the file, only a "Save As". So they can only save it under a different name (unless they purposely and maliciously went out to Windows Explorer and remove the "Read Only" property, but my guess if you are concerned will "accidental" overwriting).

The best thing about that is it doesn't require VBA, because if the user opened your file and disabled VBA, your code would never run and they would be able to alter your template and save over it.

 

[rustym]

Yeah I don't know why I didn't think about that. It works great thank you.