Results 1 to 2 of 2

Thread: protecting data validation??

  1. #1

    protecting data validation??

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can I protect a shared sheet from any changes being made to the data validation by password?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Not sure exactly what you are looking for here. If you mean you want someone to enter a password in order to make a data validation selection, then no, not really, you need to unprotect the sheet in advance of making any alterations to a protected sheet.

    If you mean to protect data validation from accidental or "purposeful" delete validation rules or "override" them by copying and pasting, then you would need a VBA function like this one:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts