View original (French)

Allow only certain users to edit a file

Solved
Annele067 -  
 Zed -
Hello,
I can't find the answer anywhere else, so I'm reaching out to you.
I would like to make it so that all users can view the Excel file, but only myself and one other person can edit it without having to enter a password each time.
I know it's possible, but I can't figure it out.
Excel 2010, I should specify.

Thank you very much

Configuration: Windows 7 / Chrome 49.0.2623.110

2 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    without having to enter a password every time
    'Review / Allow editing of ranges', you select the entire sheet and add your identifier in the access permissions.
    And you protect your sheet with or without a password.
    eric

    --
    By continuously trying, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to the thank you (yes yes, it happens!!!), remember to mark it as resolved. Thank you
    0
    1. Annele067
       
      Hello Eriiic,
      thank you for your response
      I followed the steps but as soon as I click on protect the sheet, I can no longer edit (even though I added my name beforehand).
      It’s a puzzle for me!
      Anne
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      When you clicked on Add in the Security tab, click on 'Advanced...' then on 'Search' and choose from the list to set a valid identifier.
      0
    3. Annele067
       
      Yes, Excel found my user on the network.
      1
    4. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Is it good?
      If so, remember to mark it as resolved (at the top near your title).
      0
  2. Maurice
     
    Hello

    here is a macro for 1 Admin 
     Sub TestAdmin() User = Environ("username") Admin = "Maurice" If User = Admin Then For Each Sheet In Worksheets Sheet.Select Sheet.Unprotect Next Else For Each Sheet In Worksheets Sheet.Select Sheet.Protect Next End If End Sub

    See you soon
    Maurice
    0
    1. Zed
       

      Hello

      Have you resolved your issue?

      I have a similar problem; there are several of us using the same file, some for editing and others for view-only access. My problem is that if the file is already open by someone else, I can't modify it. I would like to be able to set it to read-only for everyone except for certain users who can "enable editing" only when necessary and without having to enter a password, allowing them to modify this file. Do you know what settings would solve my issue?

      Thank you in advance

      0