- Aug 23, 2007
Hello, I work in an office where there are about 20 people that use excel templates that are found in one folder and they are *supposed* to save the template into a client folder elsewhere. The problem is that this doesn't always happen and the templates get worked in. What I would like to do is write a code that will automatically run when the template is opened, forcing the user to save as somewhere else, then when the template is saved, the autrun is disabled. Any suggestions?