I have created a "Data Form Button" for users to enter data. My worksheet involves formulas. As I have not found a way to protect the formulas when using data forms, the users, in spite of repeated training, insist on typing directly in the cells, overwriting vlookups, etc.
My solution is to protect the sheet, and have the Data Form Button unprotect the sheet, open the data form, then protect the sheet upon close.
So...
I would like to change the message that pops up when one tries to change a protected sheet so that it reads "Please press the Data Form Button".
Thanks!
My solution is to protect the sheet, and have the Data Form Button unprotect the sheet, open the data form, then protect the sheet upon close.
So...
I would like to change the message that pops up when one tries to change a protected sheet so that it reads "Please press the Data Form Button".
Thanks!