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 This is the availability you need to finish the assignment.

Format Duration - Project 2010 no longer has Microsoft's macro to format the duration of all tasks. So here's a better version that formats either all tasks, or all selected tasks only.

PERT Analysis - Project 2010 no longer has PERT calculations in it, so this is a replacement version, but on steroids!