I'm looking to add a Macro that will unlock a locked sheet
Bring a dialogue box to ask for name of restaurant
Then find all rows with value "end" in column A
Insert rows above all the rows that have "end" in column A and copying the formulas in the end row
and entering the restaurant name into column A of all the new rows from the previous query
And then relocking the sheet
Password for locked cells is "test"
Password for allowed cells is "letmein"
Bring a dialogue box to ask for name of restaurant
Then find all rows with value "end" in column A
Insert rows above all the rows that have "end" in column A and copying the formulas in the end row
and entering the restaurant name into column A of all the new rows from the previous query
And then relocking the sheet
Password for locked cells is "test"
Password for allowed cells is "letmein"