I have a file with A10 (name) and A16 (ID number) that users can key in either cell to do a search. the sheet is locked except for the two cells.
the file is working fine until i realised that if user did a ctrl c and ctrl v onto either A10 or A16, it will override the protection of the cell and caused the cell(s) to be locked. i have a marco that is supposed to clear the results by deleting the values in A10 and A16 and because of this, would not work now.
is there any way to ensure that these two cells stay unlocked regardless what the other users did? would be even better if the cell can be reverted to its original formatting (cell colour, alignment and etc.) or is there any VBA code that can revert the file to its original version (like as if it was just downloaded fresh off the website)?
this file is used by hundreds of people and educating all of them seems rather impossible. (I even had to inform a few users that they need to enable editing and enable marco before using the file.)
the file is working fine until i realised that if user did a ctrl c and ctrl v onto either A10 or A16, it will override the protection of the cell and caused the cell(s) to be locked. i have a marco that is supposed to clear the results by deleting the values in A10 and A16 and because of this, would not work now.
is there any way to ensure that these two cells stay unlocked regardless what the other users did? would be even better if the cell can be reverted to its original formatting (cell colour, alignment and etc.) or is there any VBA code that can revert the file to its original version (like as if it was just downloaded fresh off the website)?
this file is used by hundreds of people and educating all of them seems rather impossible. (I even had to inform a few users that they need to enable editing and enable marco before using the file.)