G
Guest
Dear Friends,
Let me directly go to my question.
My self and 3 of my other colleagues are working in a Project Management
Team with different roles. We use to track our work flow in the manner of
Trackers separately. But all of our 4 data will contain more than 75% of same
details. One of our 4 members is the ultimate MIS updater and we other 3 use
to collect the relevant common data daily or twice a week and update with our
records. It reflects a little time waste.
So I've planned to create a Master file, so that our MIS after updating his
file daily, the common data will be reflected in our rest 3 memeber's files.
I did this. Even though I've planned to give some Password protections to the
respective team members sheets.
For example let our Master file will be containing 10 sheets.
1st sheet will be containing our 4 names.
2nd is of the ultimate MIS executive's.
3rd and 4th will be of mine.
5-7 will be of the next one.
8-10 is for the last one member.
Now my question is that, the Master file will be available in our server and
at any time anybody can open this. While opened only the First sheet should
be Visible rest all should be Hidden/Invisible. Whenever the respective
person clicks his name, a password should be asked and after entering his
password, then his respective sheets should be visible and he can make his
update. After updating he can normally close the file. The same case for rest
also.
Kindly tell me option how to accomplish this.
My quetion is to one or more sheets by giving password and that too by
clicking the respective names/links.
Thanks and Regards,
Sriram Subramaniyan
Let me directly go to my question.
My self and 3 of my other colleagues are working in a Project Management
Team with different roles. We use to track our work flow in the manner of
Trackers separately. But all of our 4 data will contain more than 75% of same
details. One of our 4 members is the ultimate MIS updater and we other 3 use
to collect the relevant common data daily or twice a week and update with our
records. It reflects a little time waste.
So I've planned to create a Master file, so that our MIS after updating his
file daily, the common data will be reflected in our rest 3 memeber's files.
I did this. Even though I've planned to give some Password protections to the
respective team members sheets.
For example let our Master file will be containing 10 sheets.
1st sheet will be containing our 4 names.
2nd is of the ultimate MIS executive's.
3rd and 4th will be of mine.
5-7 will be of the next one.
8-10 is for the last one member.
Now my question is that, the Master file will be available in our server and
at any time anybody can open this. While opened only the First sheet should
be Visible rest all should be Hidden/Invisible. Whenever the respective
person clicks his name, a password should be asked and after entering his
password, then his respective sheets should be visible and he can make his
update. After updating he can normally close the file. The same case for rest
also.
Kindly tell me option how to accomplish this.
My quetion is to one or more sheets by giving password and that too by
clicking the respective names/links.
Thanks and Regards,
Sriram Subramaniyan