Protect the workbook under ToolsProtectionProtect Workbook for Structure and
Windows. Add a password.

After you have hidden the two sheets, of course.

Send this to the 2 users and give user1 the password to unprotect the workbook.

Note: Excel's internal security is very weak and passwords easily cracked.

If you wish to make sure that user2 cannot see the two sheets, don't include
those sheets in the file you send.


Gord Dibben MS Excel MVP

On Thu, 20 Sep 2007 05:06:01 -0700, Excel Locker <Excel
wrote:

Hi all,

I would like to send an excel file to 2 person.
I want the first one to be able to open the 4 sheets and the second person
to be able to open ONLY the first 2 sheets (therefore I don't want him to see
the 2 'banned' sheets).
Using a password is ok with me, but just can't find the way to do that (I
can hide, I can lock...but I cannot LOCK the opening itself of the sheet)

Thank you very much in advance to anyone able to help with that.

Best regards