How to protect some specific rows Column for specific users?

[Anjeet Sitoula]

I have an excel file where different users have to update the data in daily basic. I would like to know how can we protect the specific rows and column for specific users in the local area network.

 

[DaveTurton]

If you know the users' usernames you can use

application.username to return the current user's username


So

[pre]If Application.Username = (desired username) Then
'do something

[/pre]