Remove data validation on cell with password

[lesley burlingham]

I have a spreadsheet which has data validation in certain cells. I have a button to unlock the form for modification. Is it possible to have the password remove the data validation from a certain cell. And have it put back after.

 

[chirayu]

It is possible but only in conjuction with using a macro. I have attached sample file so you can look at the code.

 

[lesley burlingham]

Hi. Thank you very much for your answer. I currently have a button which unlocks the form, is it possible to add this code onto the current button. I need the validation on A4 to be >0 and <72. And have it remove when the button is presses. Put back when the form is locked.

 

[NARAYANK991]

Hi Lesley ,

I suggest that an easier way would be to leave the Data Validation intact , and use a named range called BypassDV. This will be a Boolean variable , which can be either TRUE or FALSE.

The Data Validation rule can be written to incorporate this in its logic , and the VBA code merely puts this to TRUE or FALSE depending on whether the button is pressed or the form is locked.

Narayan

 

[chirayu]

Please check