+ Reply to Thread
Results 1 to 3 of 3

Lock Data Validation Cell from Deletion

  1. #1
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Lock Data Validation Cell from Deletion

    I am trying to lock a data validation list so the user can ONLY select what is in the list and not remove the list. I know i can prevent text changes by enabling the Error Alert option but, if i am in that cell, i can still hit my DEL key and it will remove all data from that cell leaving it blank. How can i prevent that from happening?

  2. #2
    Forum Contributor
    Join Date
    03-30-2009
    Location
    dublin
    MS-Off Ver
    Excel 2007
    Posts
    104

    Re: Lock Data Validation Cell from Deletion

    Evening,

    If you selet TOOLS > Protection > Protect Sheet
    this will protect the sheet from being edited (ie DEL)
    You must first apply Formatting to all the Cells containing the Validation Lists (Select the ProtectionTab in the Format Cells Dialog Box and Check Locked)

  3. #3
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Re: Lock Data Validation Cell from Deletion

    I believe cell containg the validation list has to be unlocked in order for you to change the data in it by using the drop down selection.
    Attached Files Attached Files
    Last edited by PY_; 03-01-2011 at 06:50 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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