Project Management

Download a template to create usage logs for your Microsoft Project files

Here's a way to keep track of who has been accessing your Microsoft Project files. Download this template to create a usage log to help control and track the changes made to your project plan.


As an IT manager, you likely need to share access to your Microsoft Project plan files with other people. Maybe I am a control freak but just writing that sentence makes me tense! All those other people touching my project: It is just unnatural!

Wouldn’t it be nice to know who has opened your project and made changes to it? The standard Microsoft Project features don’t support this tracking task. But you can quickly create a log by using a short macro and by making use of the Open, Save, Print, and Close events within Project.

Download a template titled, “Create a usage log for Microsoft Project.” The template will create a new project file that contains the macros required to create a text file on your hard drive or network. This text file acts as a log file for that project and can be used to track the changes made by any person who has opened, saved, printed, or closed your project. It will also track the date and time for each of these events.

When someone opens the project, the log file will let you know if they had write- or read-only privileges. When a project is printed, the log will let you know what view was active when the printing occurred. The usage log will record the name from the User Name setting within Project—which is taken from the default settings for the user in the current installation of Office. This setting can also be accessed in Project using the Tools | Options dialog. The setting is on the General tab of this dialog box.

But you don’t need to know how it works because the macro will do the work and create the user log for you! Download this template and instructions titled, “Create a usage log for Microsoft Project.”
Need help with Microsoft Project? Post a comment or send us an e-mail. Brian can’t answer everyone’s letter, but he will write columns that will benefit the greatest number of TechRepublic members.
Read more about Microsoft Project at TechRepublic
Don't miss any of our 23 articles, columns, and downloads about dealing with Microsoft Project.
"Plan ahead with Project 2000"
"Put text where you need it on your Microsoft Project Gantt chart"
"Deploying Microsoft Project 2000"

Editor's Picks

Free Newsletters, In your Inbox