VBA Sample - Format Duration

This macro lets Project 2010 format the duration of either selected, or all tasks in the active project.

Click Here to download a Project 2010 file with the macro in it. Its free.

Before opening the project file, make sure you enable VBA macros. To do this in Project 2010:

  1. Select File, Options, Trust Center
  2. In the Trust Center click the Trust Center settings button
  3. Select enable all macros. If your organization has one, you can add a security certificate and then reduce the level of macro security if wanted.

When you open the project file, an Auto_Open macro runs and asks if you want to copy the macro to your Global.Mpt file. If you click Yes a new Ribbon tab gets created and you can run the macro from it for all open files. You don't need to have the FormatDuration project file open.

However, if the new tab does not re-appeaar next time you open Project then it is likely your IT team have made the file where your Global.Mpt file lives read only, so the macro doesn't get saved. Either get them to temporarily make the folder read-write or get them to update the Global.Mopt file for you.

If you would like a custom version of the macro, or any other macro created for you then please contact us by clicking VBA Development

This macro is Copyright ACE Project Systems Ltd 2016.
You are free to use this macro for personal use only and not sell it on.

If there are problems with the macro, please email.


Enjoy!