Protecting cells for different users

  • Thread starter Thread starter AndyOne
  • Start date Start date
A

AndyOne

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

Thanks
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected Worksheet Tab Order 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Can I protect data in a cell, but allow comments to be entered. 6
Protected worksheet allow users 1
protection 2
Using Grouped Rows in Protected Worksheet 3
Method for protecting cells which still allows quick editing 2
Protect Cells 10

Back
Top