+ Reply to Thread
Results 1 to 2 of 2

Multiple Users Locking Cells

  1. #1
    Registered User
    Join Date
    04-26-2021
    Location
    Syracuse, NY
    MS-Off Ver
    2007
    Posts
    1

    Multiple Users Locking Cells

    Is there a way I can have a sheet where multiple users can lock the cells? See reference image:

    Excel 1.PNG

    I want the titles of the cells (the bolded Date/Time, Volume, Initials, ect.) locked so no one can edit them, but allow users to input the data in the following cells, like the data on 4/26. Then, ideally, the user would lock that row of data with a password so only that user can edit it in the future. The other cells need to remain unlocked so a different user could input new data the following day and then lock it with his/her own password and continue on as such. The key being cells without data in them are unlocked so data can be added each day.

    If more explanation is needed, please let me know.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Multiple Users Locking Cells

    Hi, welcome to the forum
    I think a short answer will help you the out of your dilemma , you cannot protect only a cell or cells and even less protect individual rows with different passwords.
    The Locked cells are locked when the worksheet is protected and only one password locks it and the same one unlocks it.
    You will have to write quite an extended macro that maybe also includes a userform for the selected empty cells to be populated and once populated locked. This macro should then also include some verification routines that would permit the user that locked it to edit it (based on his/her initials)
    But if a different user may edit the same row if a cell is empty then you'll have to go deeper.

    In short, you'll have to work out a programming routine that takes care of everything, this is not just a simple help issue, if it's that important then maybe apply for a paid solution on this forum
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Excel -- Prevent users from Locking file stored on OneDrive
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2018, 04:27 AM
  2. Locking multiple cells (F4 key)
    By kestrel in forum Excel General
    Replies: 3
    Last Post: 03-29-2017, 03:38 AM
  3. Locking cell for copying but enabling users to see the content/formulas
    By lukelucky in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-25-2016, 11:31 AM
  4. Locking multiple cells F4
    By jimstrongy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-30-2015, 06:19 PM
  5. Excel 2007 : Locking Sheet But Allowing users to group
    By AlexApazidis in forum Excel General
    Replies: 0
    Last Post: 02-19-2009, 03:06 PM
  6. Replies: 1
    Last Post: 01-16-2006, 11:39 AM
  7. [SOLVED] Preventing Users From Locking a Shared Network Add-In File
    By JGeniti in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2005, 02:05 PM

Tags for this Thread

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