Can MS Office Project be set up to prevent changes to Option Setti

[ST]

Given that we entered Actual Costs manually in our project files, we want to
prevent a project file from inadvertently turning on 'Actual Cost are Always
Calculated by MS Project' Is this possible? Is it possible view Windows
Registry setting or (VBA event handler) that can help prevent this?

/Spiro Theopoulos.

 

[Rod Gill]

In the ThisProject object for your project(in the VBA Editor) you can add
the following:


Private Sub Project_Open(ByVal pj As Project)
Application.OptionsCalculation AutoCalcCosts:=False
End Sub


This will always set calc costs to manual when the project opens.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[ST]

I need something 'after the fact' so it truly prevents the possibility of a
change because this would wipe out my manually enterd cost data.

 

[Rod Gill]

That can't be done, but how about copying Actual Costs to Cost1 in the
BeforeSave event?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[ST]

Hmmm, that's not a bad idea.... But there is a problem, in the event that we
would have to repopulate our cost data....

Our program is about 3+ years long and given that we enter costs on a
monthly basis directly in the timphased view, we would run out of those costs
fields after the 20th month.

I'm wondering if using some SMS installation policy setting to deploy the
client couldn't be used to disable these options upon installation? Have you
heard of such a thing?

Thanks.

/Spiro.

 

[Rod Gill]

If this was my problem (and given my VBA skills!) I would create an Excel
spreadsheet to have all costs by Unique ID, Task Name and week or month. I
would then use a VBA macro to automatically import the data in Excel to
Project. That way if the data was ever lost, I would only need to run the
macro with all tasks set to 0% complete and all data would be updated.

This macro would not be that difficult, it just needs suitable processes and
training around using it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com