+ Reply to Thread
Results 1 to 4 of 4

Lock cell on conditional data

  1. #1
    Registered User
    Join Date
    10-30-2008
    Location
    ma
    Posts
    35

    Lock cell on conditional data

    I want to be able to lock cells in one column based on the content of cells in another column. Example, Lock C10 if A10 ="X".

    Conditional formatting doesn't include locking cells, and I can't see how to do this with an IF statement. I'm not a programmer so I'd prefer not to have to deal with VB code.

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Lock cell on conditional data

    Hi
    To do what you want you would have to use VBA code to achieve.
    Tony

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Lock cell on conditional data

    Whether this should happen for C10 alone or for every rows based on the Column-A row data?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Registered User
    Join Date
    10-30-2008
    Location
    ma
    Posts
    35

    Re: Lock cell on conditional data

    What I am actually looking for is if the cell in column U (starting at U14) = "I" then lock the equivalent cell in column AR.

    I will be happy to accept VB code but I can't write it myself.

    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. Conditional cell lock/unlock
    By caspollux23 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2010, 09:07 PM
  2. Conditional Formatting to Lock a Cell
    By Lizabeta in forum Excel General
    Replies: 6
    Last Post: 04-29-2009, 05:14 PM
  3. Conditional Lock Cell
    By Giah98 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2008, 09:42 AM
  4. Conditional cell lock
    By coolanks in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-30-2008, 09:57 AM
  5. Is it possible to set a conditional lock for a cell in Excell ?
    By Ziaee, Soroush in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2006, 12:55 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