Once they have visited the sheet and unprotected it and saved the file then
the sheets are no longer protected. What your macro needs to do is to check
the status of the sheet when it is selected to see if it is protected or not.

If activesheet.protectcontents = true then
'show your form
end if
--
HTH...

Jim Thomlinson


"socram_06" wrote:


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