+ Reply to Thread
Results 1 to 6 of 6

Data Validation Protections

  1. #1
    Forum Contributor
    Join Date
    04-22-2017
    Location
    AU
    MS-Off Ver
    Microsoft 365
    Posts
    291

    Data Validation Protections

    Hello all,

    Two issues I am experiencing with Data validation protections

    If I set cells to unlocked, then create a Data validation, then lock the Spreadsheet, I cannot access the data validation in that cell.
    Is there a VBA code to allow the Data validation to still work with a password protected Tab as I have lots of other data which should not be changed at all.

    Is there a way to prevent accidental copy and paste of other cells over the top of a data validation cell?

    Thanks

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Data Validation Protections

    If I set cells to unlocked, then create a Data validation, then lock the Spreadsheet, I cannot access the data validation in that cell.
    this doesnt sound right
    can you attach example of this in play?

    Is there a way to prevent accidental copy and paste of other cells over the top of a data validation cell?
    probably can set a worksheet_change event to monitor the cells with DV
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    04-22-2017
    Location
    AU
    MS-Off Ver
    Microsoft 365
    Posts
    291

    Re: Data Validation Protections

    Attached is a sample Workbook
    Hopefully this will assist in a solution please.
    Attached Files Attached Files
    Last edited by VisionSmart; 06-27-2017 at 07:34 PM. Reason: Added a sample Workbook

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Data Validation Protections

    when you password protect your sheet

    check "Edit Ojbects"
    then it should work as intended

  5. #5
    Forum Contributor
    Join Date
    04-22-2017
    Location
    AU
    MS-Off Ver
    Microsoft 365
    Posts
    291

    Re: Data Validation Protections

    That does not work hundingaling. - no change - as can be tested in the file I attached last post
    Further suggestions would be welcome please.

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Data Validation Protections

    attached file with the DV working on protected sheet

    Is there a way to prevent accidental copy and paste of other cells over the top of a data validation cell?
    this has to be done with VBA

    try the code suggested here
    https://superuser.com/questions/8709...cells-in-excel
    Attached Files Attached Files

+ 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. transfer data to 2nd workbook for viewing with protections
    By nvandyken in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2015, 12:57 PM
  2. Weird issue with protections
    By adamjohnson182 in forum Excel General
    Replies: 3
    Last Post: 04-08-2014, 07:37 PM
  3. Copying sheet protections?
    By Dhead97 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2007, 02:14 AM
  4. Password Protections Not Working
    By Jon in forum Excel General
    Replies: 1
    Last Post: 05-22-2006, 03:00 PM
  5. Multiple protections
    By GuyB in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2005, 07:57 AM
  6. [SOLVED] Help with Protections ASAP
    By [email protected] in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2005, 12:06 PM
  7. [SOLVED] protections for objects
    By .·:m·a·r·l·a:&m in forum Excel General
    Replies: 1
    Last Post: 02-10-2005, 06:06 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