While on Twitter today, someone was commenting that MS Project has a button allowing you to go to the start of a task in the Gantt view…

… But there is no way to click on a button and go to “Today”.  After playing around for a few minutes, I found an easy approach to do this with a macro.  If you are interested in having a button that allows you to go to the current date in teh Gantt view, I’ve listed all the steps to set it up. -Bill

For those of you who know how to create a macro and add it to your toolbar, I will save you all the steps below and just share the code:

Sub GoToTodayInGantt()
    EditGoTo Date:=Now
End Sub

If you do not know how to do this, here is the one-time step to set it up on your installed copy of MS Project:

1. Running MS Project, go to Tools->Macro->Security and set the level to Medium and click Ok.  Note that you may not need to do this step, but this is the setting I tested with.
2. Next, go to Tools->Macro->Visual Basic Editor.
3. Expand the ProjectGlobal (Global.MPT) section and then right-click on the Modules tree and choose Insert->Module
   
4. When in the module, paste the code list at the top of this post.
   
5. Close the Visual Basic editor and you should be back in MS Project.
6. Right-click anywhere in the Toolbar and Click on Customize…
   
7. In the Customize dialog box, scroll down in the Categories area and click on All Macros.  On the right-side of the screen, find GoToTodayInGantt.
   
8. Drag-and-drop the GoToTodayInGantt macro to a suitable area in the Toolbar.  In this case, I added it next to the Scroll To Task icon since it made sense to have both right next to each other.
   
9. With the Customize window still open, you can spruce up the new toolbar item a bit by right-clicking on it and changing the Name, Button Image and other elements as you see fit.
   
10. You are done!  Now anytime you open MS Project, the icon will be there.  If you do not see this on all projects, then you more than likely did not add the code to the Global.MPT file, so re-check the steps listed above.
     

One Response to “How to Create a ‘Go To Today’ Button in MS Project”