Hi Tom (or is it Cat?)
Well, Yes and no.
You can write VBA routines that fire when the file is opened, no problem.
But the question is: what do you want this program to do?
If it just activates a filter, I'm afraid you cannot stop anybody who opens
the file to select the All Tasks filter ionce the file is open and your VBA
routine has worked.
What I would suggest (but anybody's suggestion may be better than mine) is
the following:
- Let your routine Project_Open verify the presence of some file in the
machine (in such a way it will recognize you as a user)
- If you aren't the user, change names and possibly other data on the
sensitive tasks(you could imagine some simple encryption logic)
- If the user is you, and the tasks are encrypted, decrypt them.
Not easy, I know
Why give access to a file to anybody who's not supposed to see it?
Couldn't you just send a GIF file made with the Copy Picture routine?
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
TomCat said:
I need to hide some Flag1 tasks which are proprietary and very sensitive
in nature. No problem. The situation is I don't want anyone else who has
access to this schedule to be able unhide and view these flagged tasks. Is
there a way to password these by a subroutine that will run automatically
when the project is opened?