Project VBA Samples
The linked files all have useful sample VBA code that will make your use of Microsoft Project that much easier.
Scroll your Gantt Chart's Timescale automatically when you open a project.
Project 2010 - Reset Assignment Units to Remaining Work/Remaining Duration (Project 2007 behavior).

