1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Locking row by criteria in cell

Discussion in 'Ask an Excel Question' started by OrhanTAGH, Jan 3, 2018.

  1. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    Hi guys, I have project data file in which I want to lock row which is completed. I created tasks list in column L. In this list I have 6 option (pending,purchased,done,canceled,used,accepted). I want that, when I'm clicking this 5 option excepting "pending", row needs to be locked. if I want to change anything in this row I have to change option list to "pending". I want it happen in the sheet named "Project Tasks"
  2. vletm

    vletm Excel Ninja

    Messages:
    3,669
    OrhanTAGH
    Something that kind is possible to do with Macro.
    You should Upload a Sample file to get an answer ... much easier for You.
    bizlife likes this.
  3. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    good vletm, here is the file

    Attached Files:

  4. vletm

    vletm Excel Ninja

    Messages:
    3,669
    OrhanTAGH
    1st version ... and those some merged cells could be challenge ... who knows?

    Attached Files:

    OrhanTAGH likes this.
  5. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    sorry but its not working (( and I cant see the VBA macros becuase of password

    those merged cells will not be in the future I will edit them to one
  6. vletm

    vletm Excel Ninja

    Messages:
    3,669
    What do not work?
    Cannot You tell any details?
  7. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    its not locking details in row
  8. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    aa its working when you run it?
  9. vletm

    vletm Excel Ninja

    Messages:
    3,669
    1) It won't and cannot lock then whole row! ... or You cannot make new selection!

    ... hmm? ...
    if You don't use it ... how do You think that something would work?

    ... and of course Marcos have to be enabled!
  10. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    formula working but it lockes "pending" but I need lock other ones not in "pending".. In pending option I want to change but in others they need to be lock.. you did it reverse ..

    and is it possible that when I inputing new data its going to be automatically doing this
  11. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    and what is the password vletm?
  12. vletm

    vletm Excel Ninja

    Messages:
    3,669
    That's why the 1st version ... now the 2nd version - works opposite!

    NOTE: NO MERGED CELLS!
    those won't work at all!

    password ... it's Yours Chandoo username.

    Attached Files:

    OrhanTAGH likes this.
  13. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    great dude this is working perfectly )) can we do this process automatically when I input new row data?
  14. vletm

    vletm Excel Ninja

    Messages:
    3,669
    It depends how do You input new row ...
    if column 'L'-value would change in new row
    ... it would work
    ... You should test to input new row
    and
    remember that my note:
    NO MERGED CELLS AT ALL!
  15. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    When Im writing new row and choosing for example "purchased" its not doing it locked... is it possible that when Im choosing this options it will automatically affect to the input
  16. vletm

    vletm Excel Ninja

    Messages:
    3,669
    L-column's [Un]Locking works AFTER stop editing that cell! (= normally by ENTER)
    ... not while editing ... if You 'just select' ... then it's still in editing mode.
    (and after Locking ... M-column will also be locked :) )
    OrhanTAGH likes this.
  17. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    All perfect just need automatically continue of this ... or any button which will continue this process
    Last edited: Jan 4, 2018
  18. vletm

    vletm Excel Ninja

    Messages:
    3,669
    OrhanTAGH
    Please, reread #16 Reply ... Locking would happen AFTER stop editing that cell.
    Choosing is still 'editing'.
  19. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    I really dont understand ..
  20. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    For example in the row 134 .. I want to add new data and I need to select option from L ...
  21. vletm

    vletm Excel Ninja

    Messages:
    3,669
    ... okay ...
    1) You'll activate that rows cell [L134]
    2) Select from dropdown needed option
    3) PRESS <ENTER>
  22. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    I am doing as you said but nothing happens ..
  23. vletm

    vletm Excel Ninja

    Messages:
    3,669
    ... depends You selection
    that rows cells ACT like locked or not!
    Did You tried to select any cell from row 135 after that?
    >> Here it works ...
  24. OrhanTAGH

    OrhanTAGH New Member

    Messages:
    18
    I did I went to the row 135 and choose option with enter button and nothing happen still can edit that row
  25. vletm

    vletm Excel Ninja

    Messages:
    3,669
    Ouch!
    There have to be filled at least 'Start Date' (B-Column)!​
    ...
    hmm ... Test this version.

    Attached Files:

    Thomas Kuriakose and OrhanTAGH like this.

Share This Page