hello
is there any way protect and unprotect the sheet based on input box? the first time when I select any cell then show input box I enter my password then protect the sheet and when select any cell shows the message has tow choice " do you want change the password " if press ok then show inputbox again and enter a new password and protect the sheet and if press no then show the inputbox and enter old password to unprotect the sheet if the password wrong after entering twice should show message " sorry you have only two tries " and close the inputbox with stay the active sheet and if the password is right then should unprotect the sheet but with considering when before close the file of course it will save the changes in sheets also protect based on the last password is entered
I hope my post is clear
is there any way protect and unprotect the sheet based on input box? the first time when I select any cell then show input box I enter my password then protect the sheet and when select any cell shows the message has tow choice " do you want change the password " if press ok then show inputbox again and enter a new password and protect the sheet and if press no then show the inputbox and enter old password to unprotect the sheet if the password wrong after entering twice should show message " sorry you have only two tries " and close the inputbox with stay the active sheet and if the password is right then should unprotect the sheet but with considering when before close the file of course it will save the changes in sheets also protect based on the last password is entered
I hope my post is clear