Hello
How do I set up code to set up a button or buttons that clear the ranges (b9;h9, b12;h12, b19;h19,, b21;h21, b31;h31 the ones for passcode entries) at the end of the week and automatically unlock them so that the sheet is ready for the next week's entries
The current manual way of accomplishing is rather intricate and not straight forward, clearing line by line
please see file in dropbox /s/bn19sjy5pfb8bq7/sample%20sheet%201.xlsm?dl=0
could not add as attachment
Ideally the reset button(s) is to be in the other sheet called setup
Thank You
Bookmarks