i'm not sure if it helps
try using workbook's beforesave event.

add the condition
whenever usr want to save he must close the current workbook.

you can make sure the path where he saves by thisworkbook.fullpath

or whether he is using the saveas method then disallow him by making
cancel=true so he wont use saveas only and save changes to current
workbook only


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