+ Reply to Thread
Results 1 to 7 of 7

Provide permission to others to write, but not to edit in excel

  1. #1
    Registered User
    Join Date
    12-24-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2013
    Posts
    4

    Provide permission to others to write, but not to edit in excel

    Hello everyone, I have a doubt... is there any option in excel in order to protect the workbook from editing, but at the same time others should be able to add the data without able to edit the data. Could you help me on this...

    In simple words, protect the workbook from editing but giving access to write.

    Others should only able to write and once it is saved it can't be modified...

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Provide permission to others to write, but not to edit in excel

    is there many users at the same time?
    actually excel isn't very good for protecting information

  3. #3
    Registered User
    Join Date
    12-24-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2013
    Posts
    4

    Re: Provide permission to others to write, but not to edit in excel

    Dear Mr. Tim201110,

    Good morning!

    Thank you for your response.

    To answer your question, Only one user at the same time. Actually, I want to give an empty excel work book to my colleague to update the daily entries. I will place this excel in a common folder. If he updates today's entries and save it, then it should not be modified. He should not have the privilege to edit the entries. Again, next day he will start entering the data. My intention is there should not be any changes in the excel intentionally or un intentionally. If he wants to correct something, let him come to me to correct it. I hope I made you understand my query.

    Awaiting for your valuable suggestion.

    Once again thank you.

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Provide permission to others to write, but not to edit in excel

    best solution:
    one file for user and one for admin, and macro for reading data from user file

  5. #5
    Registered User
    Join Date
    12-24-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2013
    Posts
    4

    Re: Provide permission to others to write, but not to edit in excel

    Dear Mr. Tim201110,

    Good evening!

    Thank you so much for your solution, could you help me on forming macro for the same.

  6. #6
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Provide permission to others to write, but not to edit in excel

    iit's just an idea.
    i've not even seen what y want

  7. #7
    Registered User
    Join Date
    12-24-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2013
    Posts
    4

    Re: Provide permission to others to write, but not to edit in excel

    It's okay Tim201110, thank you for your suggestion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 12-05-2014, 03:47 PM
  2. [SOLVED] Force read only / acquire write permission
    By smpita in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2014, 04:48 PM
  3. Replies: 0
    Last Post: 07-24-2014, 08:59 PM
  4. Replies: 0
    Last Post: 04-07-2014, 10:01 AM
  5. Edit range permission
    By hdbrandon in forum Excel General
    Replies: 0
    Last Post: 07-06-2011, 12:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1