locking columns

[Rachael]

Is there a way to lock some of the columns in your
schedule so that you can send it out but people can only
up date the one column free.

Thanks,
Rachael

 

[JackD]

No, not really.
There is no way to lock it securely.

-Jack

 

[John]

Racheal,
Unfortunately no. However there are a few "tricks" you can use to
prevent unauthorized changes. The easiest method, although not
particularly effective, is to simply remove the sensitive fields from
the view the user sees. Of course all a savy user has to do is add the
field and make changes. A second more effective approach is to replicate
the sensitive fields in obscure spare fields and then employ a formula
to populate another spare field if changes are made to the primary
field. Again, a more sophisticated user could thwart this approach. The
most effective but more complex approach is to set up an Event macro to
trigger if a change is attempted on the sensitive field(s).

Hope this helps.
John

 

[Mark Durrenberger]

If you want to get really fancy, you can write VB as an add in and using the
"On task change" event, trap and reject changes to certain fields.
Unfortunately, add-ins are un-installable so the clever user will get around
it... :-(

Mark



--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones