Macro to Protect Unprotected Cells on worksheet

[nsmjc]

I have a workbook with several complicated formulas in it.

Therefore I have the worksheet protected save the cells to enter data into.

Is there a Macro that could be run after the data is entered which will protect the data entered into the unlocked cells.

I can record a macro and it asks me to enter a password to open unlock the sheet.

I would like the macro to do the following

1- When ran ask the user if they are sure they want it to secure the worksheet

2- If the user selects yes then lock the entire work sheet including the cells which the user can change the data in.

3- If the user selects no the the Macro will stop running.

Attached is a simple worksheet with what I have been able to do.

Thank you for any assistance yo may be able to give.

[Olly]

Try:

Please Login or Register  to view this content.

[nsmjc]

that worked thank you