Dear Mike,

Thanks for your below help for my earlier problem. Now I've come up with
another problem, can you please solve it for me.

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 around 50% of same
details. One of our 4 members is the ultimate MIS updater and we other 3 use
to collect the relevant common data once 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 protection to the
respective team member's 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 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 Show / Make Visible one or more sheets by giving password
and that too by clicking the respective names/links.

Thanks and Regards,
Sriram Subramaniyan


"Mike Fogleman" wrote:

You have done good so far, but you still need to qualify the IF statement in
the cell. The first argument always requires some kind of comparison like =,
<, <, , etc. So just add a comparison to your first argument. In your case
it would be:

=IF(Forma1="NA",Forma1,Forma2)

Mike F