Basically I have some templates setup that are designed to have data copy/pasted from our computer systems, then you run a macro to format the data and do some other tricks.
These templates are designed for a variety of users, and usually once every few weeks someone screws the template up and saves over it-rendering it useless. I of course keep archived backups that I use to replace these files, but I was wondering if there was a way to setup the workbooks so you could restrict people from saving over the template-instead when you go to save you have save as something else...
Can this be done?
Bookmarks