Password protect worksheet for multiple users

**Crüe** · 10-03-2011, 02:26 AM

Hello,

let's say users A and B share same protected workbook. User A wants to edit workbook, then he protects it again with password. Then user B wants to edit this same workbook, but he CANNOT edit, delete etc cells user A just modified. How can I do this or is this even possible??

In a nut shell, same workbook with password protection, Users A and B both have the same workbook, User A modifies workbook, then protects. User B modifies workbook but cannot edit user A's cells.

Maybe I could use macro-code?? So that when user A opens workbook, it asks "User name" and "Password", then he can edit workbook. Same thing with user B, is this possible??

Thanks in advance!

**royUK** · 10-03-2011, 02:41 AM

Are the cells all on one sheet?

You won't be able to do this without VBA

**Crüe** · 10-03-2011, 02:46 AM

Well, there's actually 3 sheets. Let's say they're "Sheet1", "Sheet2" and "Sheet3". I would really approciate any help

**royUK** · 10-03-2011, 03:03 AM

Does each sheet apply to one user. i.e is that what they need access to?

**Crüe** · 10-03-2011, 03:05 AM

Oh forgot to mention :/ each user needs to have access to edit cells AU23:BA24 on each sheet

**Crüe** · 10-03-2011, 03:22 AM

I found this on previous threads, I tried to modify it little but it gives me an error "Application-defined or object-defined error"

Please Login or Register  to view this content.

**grizzly6969** · 10-03-2011, 03:51 AM

cross post
http://www.mrexcel.com/forum/showthread.php?t=582848

**royUK** · 10-03-2011, 04:15 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this