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
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    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: http://spreadsheetpage.com/index.php...s_not_deleted/


Posting Permissions

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