The best approach is never to turn off the Modified flag manually, but to use a programmatic method. You can create a simple worksheet form which can help you do so, or you can download the Version Tracking tool from our book web site www.teachmenav.com.
The instructions are contained in the readme.txt file in the attached zip.
Nice, but no object locking!
The tool raises an error when saving modifications and the object is checked out by someone else.
But imagine the following situation:
1. User 1 opens an object in design mode (but did not check the object out)
2. User 2 checks out the same object, opens the same object in design mode, makes changes, saves the object modifications and checks the object in
3 User 1 makes modification and wants to save the object, but the tool raises an error (which is good). Now User 1 checks out the object (the object is still in design mode) and saves the changes. The object is saved. But because User 1 opened the object in design mode before user 2 and saved the object after User 2, the modifications of User 2 are overwritten and lost!
It would be nice to have a tool that locks objects before opening them in Design mode.