title: Force Save As, MS Excel VBA
body: <p>I'm a bit of a newby with VBA in MS Office products. I've been searching for some code that will force a user to "Save As' a .xls file I use as a template (but it's not an actual template file type) </p>
  
  <p>Basically, I have this:</p>
  
  <ol>
  <li>User opens .xls, enters some data into some field and then File-->Save As to their own location</li>
  <li>Sometimes user clicks save instead, therefore overwriting the .xls which I don't want to happen.</li>
  </ol>
  
  <p>I've been looking into some ideas, but I'm not sure how to implement it the best. I think a prompt when the user first opens the .xls to save to a new location is the best approach, but thinking forward, if they have already saved the file to a new location and decide to edit the new one, I want them to be able to 'Save' at that point because now it is their own file, not the original. </p>
  
  <p>If someone can point me in the right direction or find flaws in my logic, I'd love to hear it.</p>
  
  <p>Thanks,
  Mike</p>