Save a backup copy
Save a dated copy of the workbook before you make big changes.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Save a copy named Backup
- Show "A backup copy was saved."
Use it in MacroRoni: open the Starter gallery, search for "Save a backup copy", 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 & 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 onSheets & safetyShow everything that is hiddenUnhide every sheet, plus the hidden rows and columns on this sheet.Doesn't change values