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

In general to hide a sheet that cannot be opened by using the application
toolbars use this code inside your programme...

Sheets("Sheet1").Visible = xlVeryHidden

To make the sheet visible again use this...

Sheets("Sheet1").Visible = True

I think you will need to create a userform that opens when your user wishes
to unlock his sheets, I would recommend that you write a sign on routine
that asks for a username and password when the workbook is opened, to then
automatically "unlock" e.g. make visible sheets that that user can change.
To achieve this you should create a logon sheet (very hidden) that stores
valid users and their password. Is this what you want?


--
Cheers
Nigel



"Sriram" wrote in message
...
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