Protecting cells for different users
 

I have a excel sheet that will be processed by different users. Is it
possible to protect cells to be used only by one user?

Thanks?


--
AndyOne
------------------------------------------------------------------------
AndyOne's Profile: http://www.excelforum.com/member.php...o&userid=20217
View this thread: http://www.excelforum.com/showthread...hreadid=385638

Why not just give that user the password to Unprotect?

ToolsProtectionAllow users to edit range


--
julie
------------------------------------------------------------------------
julie's Profile: http://www.officehelp.in/member.php?userid=236
View this thread: http://www.officehelp.in/showthread.php?t=697968
Visit - http://www.officehelp.in | http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.php

You could use VBA to unprotect the worksheet when a specific user opens it.
e.g.

Private Sub Workbook_Open()
If Application.UserName = "John Smith" Then
ActiveSheet.Protect
Else
ActiveSheet.Unprotect
End If
End Sub


"AndyOne" wrote:


I have a excel sheet that will be processed by different users. Is it
possible to protect cells to be used only by one user?

Thanks?


--
AndyOne
------------------------------------------------------------------------
AndyOne's Profile: http://www.excelforum.com/member.php...o&userid=20217
View this thread: http://www.excelforum.com/showthread...hreadid=385638