H
Helen
Is it possible in VBA to lock a task so that it cannot be deleted. We have
certain milestones and tasks that MUST be in the plan.
certain milestones and tasks that MUST be in the plan.
J
John
Helen said:
Helen,
Is it possible, yes, and there are a few different methods you can try.
For a non-VBA approach you can use a write reservation password with
read-only recommended. However this doesn't help much if the users must
be able to update their task status or otherwise modify the plan.
For a covert VBA solution, you could create an "auto" type macro that
runs any time someone attempts to change one of the critical milestones.
It could simply warn the user that the milestone is "sacred" or it could
potentially prevent the file from being saved. To learn more about auto
type macros (i.e. Event based) go to Jack Dahlgren's, (a fellow MVP),
website at:
http://masamiki.com/project/macros.htm
and read the section on "Run on Open and other events". I'm not sure but
is that kinda like "Running on Empty" as Jackson Browne sang? Sorry,
sometimes my mind wanders
For a more overt approach you could try a good dose of training so the
users understand what elements of the plan must be present. Granted,
some users tend to forget their training but it is still a good place to
start and you could run a file comparison utility to monitor their
discipline.
Hope this helps.
John
Project MVP