Shared Workbooks

Hi,

how can i protect and unprotect the worksheet in a shared workbook using vba.. the shared workbook will reside in a network drive to be able to access by the users.. the worksheet in a shared workbook is assigned to 1 user (1 worksheet = 1 user), he/she the only one can change in that worksheet..
i'm using office 2000..

thanks..

What i understand is that lets say there are three users of your shared workbook For instance Steve, Jack and Rachel. You want each of the users to be able to access only their own sheet on that shared workbook

If so, does that shared workbook requires password to get opened? If so, is there is a common password for all of the users to log-in (in other words, you used MS EXCEL's own password protection option) OR are you having a custom built Log-in form and all users are assigned different passwords?

this is necessary to undestand before i can comment...