+ Reply to Thread
Results 1 to 2 of 2

Keep just one cell with data validation (value box) operatable in a protected excel sheet

  1. #1
    Registered User
    Join Date
    03-12-2025
    Location
    Turkey
    MS-Off Ver
    Microsoft 365
    Posts
    1

    Keep just one cell with data validation (value box) operatable in a protected excel sheet

    In my Excel 365 worksheet: I want to lock my worksheet "Home" but just let a data validation value box (not form or active-x combobox), assigned to a cell ("I6"), operatable.
    That means the users shall be able to select a value from the data validation box, but not be able to change the format and other things.

    I have tried so manythings but didnt work. In general I have tried this way:

    Please Login or Register  to view this content.
    But each time the worksheet gets protected, an I cannot select a value from the data validation value-box in cell "I6".

    When I comment out the line starting with .Protect, the whole sheet gets unprotected. So I am sure that there is no other code part that is causing the issue.
    Last edited by AliGW; 05-02-2025 at 03:41 AM. Reason: Code tags added - please review the forum guidelines.

  2. #2
    Forum Contributor
    Join Date
    01-07-2025
    Location
    Iran
    MS-Off Ver
    Pro.Plus.2024.v2502
    Posts
    161

    Re: Keep just one cell with data validation (value box) operatable in a protected excel sh

    To solve this issue, the cell "I6" must be unlocked, and the worksheet must be protected with settings that allow the use of the data validation dropdown.

    Please Login or Register  to view this content.
    Life unfolds as we shape it.

+ 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. data validation multiple selection protected sheet
    By Simon.xlsx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2016, 07:32 AM
  2. Unable to use data validation in protected sheet
    By vimal768 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2014, 06:16 AM
  3. Combobox Data Validation on Protected Sheet
    By medz80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2014, 01:40 AM
  4. ComboBox/Data Validation won't work when sheet is protected.
    By Butler82Paul in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2013, 11:38 AM
  5. Can't add Data Validation to Protected Sheet
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-20-2011, 07:52 PM
  6. Changing cell validation on a protected sheet
    By agentsmith83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2011, 12:33 PM
  7. List, Data Validation, unlocked cell, protected sheet.....
    By Kane in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-08-2005, 07:06 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