Unlock, date-stamp, lock again
Remove protection, write today's date in B1, then protect the sheet again.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Unprotect the sheet
- Write today's date in B1
- Protect the sheet
Use it in MacroRoni: open the Starter gallery, search for "Unlock, date-stamp, lock again", 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 & safetyLock the finished sheetAsk first, then replace formulas with their results and protect the sheet from edits.Changes data · backup on