+ Reply to Thread
Results 1 to 3 of 3

lock cell after selected value

  1. #1
    Forum Contributor
    Join Date
    01-19-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2016
    Posts
    133

    lock cell after selected value

    What can I do in Excel this: in a cell to choose from a list value, when I chose the value in the list to the cell block.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: lock cell after selected value

    In the attached example, we start with all cells unlocked and the worksheet unprotected. Once the user has entered a value in cell C4, an Event macro locks that cell and protects the worksheet. Macros must be enabled for this to work.
    Attached Files Attached Files
    Gary's Student

  3. #3
    Forum Contributor
    Join Date
    01-19-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2016
    Posts
    133

    Re: lock cell after selected value

    Thank you. but if you want the list to be in a certain cell, how do? .. if I copy the list in cell C4 in another cell does not work.

+ 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. How to lock down other Form Control Checkboxes when one has been selected?
    By PinkieAce in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-04-2012, 05:46 PM
  2. how to hide and lock only few selected cells
    By gr8ice in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-30-2011, 12:07 PM
  3. MAcro to lock and unlock cells depending on rows selected.
    By ballack in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-25-2007, 11:04 PM
  4. [SOLVED] How to Lock the selected cells in Excel worksheet
    By Siva in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-08-2006, 06:55 AM
  5. How do I lock selected cells, so only I can change them?
    By Robert in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2006, 12:45 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