Hi there...

I have a protected workbook with 17 sheets, all of them protected with
different passwords.

When the user is in the sheet1 and then passes to the sheet2, he'll
have to type his "username" and "password" for this sheet (using a
UserForm), having to do the same, passing to sheet3, sheet4 and so
on...

The answer is:

how to liberate only the sheets already opened by this user, even after
he/she has closed the workbook ???

It means that when this user re-open the workbook, only the password
for this step (workbook) and of course for the sheets still closed (not
yet visited), will be requested...

Is it possible ??

Any help would be very appreciated... Thanks

Marcos.


--
socram_06
------------------------------------------------------------------------
socram_06's Profile: http://www.excelforum.com/member.php...o&userid=35983
View this thread: http://www.excelforum.com/showthread...hreadid=565474