Selective password control

[Brisbane Rob]

I have a workbook with six sheets sitting on a server and accessed by two gorups of people. One group is allowed to look at all six sheets, the other only at two. Is it possible to control this access via a password? ie for one group on two sheets would show?

Thanks for any ideas

[exceluserforeman]

I think you need a userform with password textbox.

http://www.geocities.com/excelmarksway

"Brisbane Rob" wrote:

>
> I have a workbook with six sheets sitting on a server and accessed by
> two gorups of people. One group is allowed to look at all six sheets,
> the other only at two. Is it possible to control this access via a
> password? ie for one group on two sheets would show?
>
> Thanks for any ideas
>
>
> --
> Brisbane Rob
> ------------------------------------------------------------------------
> Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
> View this thread: http://www.excelforum.com/showthread...hreadid=510187
>
>