Mark an Excel File as Complete and Final Version
This feature allows you to make an Excel file that tells everyone that it is the final version, the completed version.
This is great when you need to send a file to someone while at the same time letting them know that no further changes need to or should be made to the workbook.
Note: this feature does not prevent a user from making changes to the workbook. It merely informs them that no further changes need to be made.
Steps to Mark a Workbook as Final
- Click the File button:
- Go to the Info section:
- Click the Protect Workbook button and then Mark as Final:
- Hit OK on the window that appears:
- Depending on your settings another window may open, hit OK on there too:
- That's it!
The next time you, or anyone else, open the file, a notification message will appear at the top of the window:
If the user then clicks Edit Anyway and edits and saves the file, it will no longer be marked as final.
Notes
I just want to repeat that this feature does not prevent the editing of a workbook. It merely tells someone that this is the final version.
Tutorial: How to export an Excel file to a CSV file (comma separated values file). This allows you...
Tutorial: This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods...
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Macro: Free Excel UDF to display the name of the current Excel workbook, including the workbook e...
Tutorial: Simple way to open an Excel workbook using VBA and macros. Syntax Workbooks.Open ("File...
