Excel Passwords

[Donald]

If I have an Excel Workbook and I have six people sharing the same workbook, is there any way I can set permissions so they each control certain pieces of the workbook so the objective is when one person is in the workbook he or she can only change her info and not others.

 

[JazzSP8]

If its shared over a network then you could look into protecting or unprotecting certain worksheets based on the username, something along the lines of;

Dim User As String
User = Environ("username")
If User = "JazzSP8" Then
Sheet1.Unprotect (PASSWORD)
Sheet2.Protect (PASSWORD)
End If

Place something like that the ThisWookbook module, it works for me on one of my spreadsheets...

 

[Peter1973]

Looked at this and it look slike something that would be very usefull but not too good on vba any chance you could explain why it works ive tried copying it in but not worknig. Does it ony work on a network ?