Protect Fields against edit

M

Mask

Good morning developers,


I'm using MS Project 2007 and developing some Macros.
I would like to know if there is any way to protect fields against
change.

Example:
I would like to protect my field duration against change. I know I
need to make program 1 Macro using Events, to catch my action and
treat it. I can't find a method that make my fields not "enable". We
can use enable method to a field form but what I really would like to
know is how to protect Ms Project table fields

Any help would be good,

Best Regards,
Mask
 
J

Jack Dahlgren

The short answer is No.

As you are aware, you could trap some of the built-in events
(beforetaskchange etc.) to cancel edits to a field, but all that needs to be
done is disable macros for people to edit the fields. There is no robust
locking mechanism for project fields.

You can detect changes to the fields though. Set a baseline and then compare
baseline duration to duration. Using Project Server, the baseline fields can
be protected from change by an administrator.

-Jack Dahlgren
 
M

Mask

Ty for your help Jack.

The short answer is No.

As you are aware, you could trap some of the built-in events
(beforetaskchange etc.) to cancel edits to a field, but all that needs to be
done is disable macros for people to edit the fields. There is no robust
locking mechanism for project fields.

You can detect changes to the fields though. Set a baseline and then compare
baseline duration to duration. Using Project Server, the baseline fields can
be protected from change by an administrator.

-Jack Dahlgren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top