How about password protecting the document so the user has to rename
the file to save it?

Rollin_Again wrote in message ...
I have a workbook that several people at work will be using. I want to
keep the orignal workbook intact and force the users to rename the
workbook whenever they try to re-save it.

Is it possible to add some code to the Workbook_BeforeSave event and
determine whether the file is being saved with the original filename?


Rollin


---
Message posted from http://www.ExcelForum.com/