Originally Posted by Wtz-44
I've made a couple of templates for a friend of mine, and they are on her computer as read only.
The problem is, instead of opening the template, filling in the values and saving it as a new document, she keeps opening the last document she saved, altering a few values and saving it over itself.
These documents are invoices and stock tables - so thats the last thing she should be doing.
Is there a way to force any documents saved to be 'read-only' - so that she is forced to save any file she alters as a fresh copy?
Shes using office2007
You could put a button on the template with a macro behind it to perform the save for her. In this way you can apply a password to modify forcing the new document to effectively be Read Only.
Happy to write the macro for you if you think that might help, but start by looking at the VBA command Workbook.SaveAs and using the WriteResPassword switch.