Lock the finished sheet
Ask first, then replace formulas with their results and protect the sheet from edits.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Ask Yes or No first
- Turn formulas into values in A1:Z1000
- Protect the sheet
Use it in MacroRoni: open the Starter gallery, search for "Lock the finished sheet", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More sheets & safety macros
Sheets & safetySave a backup copySave a dated copy of the workbook before you make big changes.Doesn't change valuesSheets & safetyFormat every sheet the sameStyle the header, freeze the top row and fit columns on every sheet in the workbook.Doesn't change valuesSheets & safetyShow everything that is hiddenUnhide every sheet, plus the hidden rows and columns on this sheet.Doesn't change values